Help Please: ErrorSQL query:-- -- Dumping data for table

[webbit]

Hi Eveyone!

 

I have had to do re-install of the prestashop engine, a template for my store

 

I now want to import the 'REAL" data that I had in my store (prior to the re-install) from a backup file.

 

On trying to upload it via myphpadmin (also tried using the sql tab in myphpadmin- pasting the text from the backup file)

 

I get the following error

 

ErrorSQL query:-- -- Dumping data for table `ps_access` -- INSERT INTO `ps_access` (`id_profile`, `id_tab`, `view`, `add`, `edit`, `delete`) VALUES (1, 1, 1, 1, 1, 1), (1, 2, 1, 1, 1, 1), (1, 3, 1, 1, 1, 1), (1, 4, 1, 1, 1, 1), (1, 5, 1, 1, 1, 1), (1, 6, 1, 1, 1, 1), (1, 7, 1, 1, 1, 1), (1, 8, 1, 1, 1, 1), (1, 9, 1, 1, 1, 1), (1, 10, 1, 1, 1, 1), (1, 11, 1, 1, 1, 1), (1, 12, 1, 1, 1, 1), (1, 13, 1, 1, 1, 1), (1, 14, 1, 1, 1, 1), (1, 15, 1, 1, 1, 1), (1, 16, 1, 1, 1, 1), (1, 17, 1, 1, 1, 1), (1, 18, 1, 1, 1, 1), (1, 19, 1, 1, 1, 1), (1, 20, 1, 1, 1, 1), (1, 21, 1, 1, 1, 1), (1, 22, 1, 1, 1, 1), (1, 23, 1, 1, 1, 1), (1, 24, 1, 1, 1, 1), (1, 26, 1, 1, 1, 1), (1, 27, 1, 1, 1, 1), (1, 28, 1, 1, 1, 1), (1, 29, 1, 1, 1, 1), (1, 30, 1, 1, 1, 1), (1, 31, 1, 1, 1, 1), (1, 32, 1, 1, 1, 1), (1, 33, 1, 1, 1, 1), (1, 34, 1, 1, 1, 1), (1, 35, 1, 1, 1, 1), (1, 36, 1, 1, 1, 1), (1, 37, 1, 1, 1, 1), (1, 38, 1, 1, 1, 1), (1, 39, 1, 1, 1, 1), (1, 40, 1, 1, 1, 1), (1, 41, 1, 1, 1, 1), (1, 42, 1, 1, 1, 1), (1, 43, 1, 1[...]

 

any info would be much appreciate as I know nothing about sql

 

Thank You

Edited November 15, 2012 by webbit (see edit history)

[Dh42]

How did you create the sql backup? you should upload the sql file to an empty db usually, unless you used some method that assumes all of the tables are already created.

[webbit]

Hi Thanks for your reply

the back up was from myphpadmin and I also exported one from within the Prestashop admin/tools/db backup

Both had the same ErrorSQL query error

 

On import I thought it would just over write , so I didn't have to drop the existing tables

[Dh42]

if you have a mysql dump, you have to drop all the tables in the existing db for the site before you can upload it, or you can go thru manually and take the table creation out. But I just drop them all, myself.

[webbit]

I took your advice and dropped all the tables

Issue solved , kind of

Firstly I made sure both login passwords were the same for both prestashop admins

I then dropped all the tables

and imported the back up db

The only things missing are some images, i think is because i previously used 'move images' in preferences/ images

[Dh42]

You might be able to get them back by regenerating the images, how many are you talking about are missing? It could be easier to just upload them again.

[webbit]

yeap will do both thank for your help

[Dh42]

No problem.