SOLVED LOST SHOP (please help me!)

[chivoto]

I have deleted both my prestashop/ folder and the database.

I have a complete .tar of the folder and some DB backups (but sadly I had the "Don't save all tables" option in the DB backup tool). How can I restore it, please!!!?

When I created a new database in PHPmyadmin with the same name and reinstalled PS I get this when trying to import the DB backup:

SQL query:

/* Scheme for table ps_access */ CREATE TABLE `ps_access` (
`id_profile` int( 10 ) unsigned NOT NULL ,
`id_tab` int( 10 ) unsigned NOT NULL ,
`view` int( 11 ) NOT NULL ,
`add` int( 11 ) NOT NULL ,
`edit` int( 11 ) NOT NULL ,
`delete` int( 11 ) NOT NULL ,
PRIMARY KEY ( `id_profile` , `id_tab` )
) ENGINE = InnoDB DEFAULT CHARSET = utf8;

MySQL said: Documentation
#1050 - Table 'ps_access' already exists

[chivoto]

“Don’t save all tables” option

This would not cause a problem. The "extra tables" store only logged visitor data -- data used by stats modules. In terms of functional backup, they basically amount to "bloat". That's the rationale for providing an option to exclude 'em.
.
I'm relieved to hear that you're using phpmyadmin.
.
Prior to running the installer, drop all tables via phpmyadmin.
Run the installer.
Return to phpmyadmin and drop all tables (yes, again)
Import your backup via SSH mysql commandline
mysql -uUSERNAME -pPASSWORD DATABASENAME < MYBACKUPFILE.sql
( or paste the content from your 1238uadf.sql backup file into the phpmyadmin "SQL" box and click "Go!" )
Visit your BackOffice login URL and verify S'okay.
Visit your FrontOffice and verify the homepage loads.

Thank you, it worked great!