Problems copying database from MySQL 5.1 to 5.0

[zc_fan]

Hi there smart folks, help this new zenner.

I am using Zen Cart v1.3.9 and have installed WAMPServer 2.0 (thanks for DrByte's suggestion) on my local Win 7 64 bit PC to develop my site locally. I was successful to a large extent so I started adding products locally on my PC. I am running MySQL 5.1.36 which got installed with WAMPServer 2.0.

I exported a .gz file from local server to import into the hosting company's server database. Now my hosting company has MySQL 5.0 instead so to my surprise when I import the .gz file it throws an error. I have tried the export option MySQL40 as well MYSQL but no success.

So can/should I downgrade to 5.0? Is there is a way to export 5.1 database and import into 5.0? Can I use Access as a middleware for this export/import?

Again, folks, thanks for your help.

[kobra]

when I import the .gz file it throws an error.

So can/should I downgrade to 5.0? Is there is a way to export 5.1 database and import into 5.0? Can I use Access as a middleware for this export/import?

What error?
Do a proper DB Backup & re-try
https://www.zen-cart.com/tutorials/i...hp?article=103

[nigelt74]

Hi there smart folks, help this new zenner.

I am using Zen Cart v1.3.9 and have installed WAMPServer 2.0 (thanks for DrByte's suggestion) on my local Win 7 64 bit PC to develop my site locally. I was successful to a large extent so I started adding products locally on my PC. I am running MySQL 5.1.36 which got installed with WAMPServer 2.0.

I exported a .gz file from local server to import into the hosting company's server database. Now my hosting company has MySQL 5.0 instead so to my surprise when I import the .gz file it throws an error. I have tried the export option MySQL40 as well MYSQL but no success.

So can/should I downgrade to 5.0? Is there is a way to export 5.1 database and import into 5.0? Can I use Access as a middleware for this export/import?

Again, folks, thanks for your help.

what is the error it gives?,
have you tried exporting as an .sql file rather than .gz?

[zc_fan]

http://picasaweb.google.com/baggagau...06789013343634

Here is a link to error message on the hosting company's phpMyAdmin

Thanks for looking into it.

[zc_fan]

I haven't tried the .sql file but will give it a try now. The reason I was using .gz is because of the compression. Right now I have a very small DB but I was thinking about scaleability.

[kobra]

I exported a .gz file from local server to import into the hosting company's server database.

Are you creating a backup ussing the tutorial?
What is the collation on your local and on the host?

[zc_fan]

I used the following tutorial for DB export.

https://www.zen-cart.com/tutorials/i...hp?article=103

But the problems seems to have resolved for now by the following:

Previously I had been doing a full database export and import. This time I exported the tables from the SQL tab of the DB, not the SQL from phpMyAdmin from within the local DB and then imported the tables via the SQL tab of the database, not the SQL from phpMyAdmin, it seems to have worked.

Now I am not sure why did this work? And is it a good long term solution?

[kobra]

Now I am not sure why did this work? And is it a good long term solution?

Could not follow what you outlined....
But if you follow the tutorial then this is the proper way