Problem Importing SQL database to new database ready for testing Zencart 1.5

[RodG]

Just starting the process to upgrade from 1.3 to 1.5, but have fallen at first hurdle. I have exported my existing Zencart Database from PHPmyAdmin using the Zencart recommendations for settings, I then try to import my exported database to my new database ready to test Zencart 1.5 and make all the mods, but I keep getting the error message, shown below. I have listed the first table code. I am sure this is caused by the options I am using in export but I just cannot work out how to fix it.

As lhungil has cleverly observed, this could be (read: Probably is) related to a bug in an older version of phpmyadmin.

All is not lost though - You could ask your hosting provider to update this software - OR, you can try this.

1) Install ZenCart V1.5 on the new server - but DON'T install the demo/sample products.
2) Using phpmyadmin on the new server select the database. (this should give you a list of all the tables).
3) Click the 'empty' button on any tables that have more than '0' rows. (or select all tables, then select 'empty' from the dropdown box)

4) On the old server do another 'export' using the same settings as you did previously, but this time make sure the option
"Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT statement" is UNCHECKED.
5) Try the import again.

Sorry, but I can't *guarantee* that this will work because there could be differences in the table structure between the two difference versions of ZenCart.

If it doesn't work, you could also try exporting/importing as a two step process.
On the first export, select 'structure' (rather than structure and data). Ensure the
"Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT statement" is CHECKED.
Import this into the new server. If there are no errors, go back to the original server and perform another export of just the 'data' (rather than structure and data). Ensure the
"Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT statement" is UNCHECKED.
Import into the new server

Again, I can't guarantee that this will work, but if it does fail it will do so when trying to do the 1st import (the 'structure').

If *neither* method works, and your host won't update their phpmyadmin version, there are still other methods possible, but I feel it best to not go there at this point in time. Please do let us know though.

Cheers
RodG

[gillpotsoffun]

I have passed this to my host and hopefully they will either have a solution or update the phpmyadmin. If not then I will try your suggestions. I will keep you posted.

[gillpotsoffun]

My host did not suggest upgrading Myphpadmin, but said I should copy the database, which I have done and I have managed to get it to work! Thanks for your suggestions problem solved, for this purpose.

[RodG]

My host did not suggest upgrading Myphpadmin, but said I should copy the database, which I have done and I have managed to get it to work! Thanks for your suggestions problem solved, for this purpose.

Thanks for letting us know that you've solved the problem, but I have to ask, How did you manage to copy the database? Most people don't have direct access to the database files to be able to do this.

Cheers
RodG