Trouble updating database

[RodG]

Thank you for your reply. Yes, in checking the databases in MySQL I see that my new database has only 162 tables and not the right Mb of info versus my 250 tables in my v.1.5.3.

Although the number of tables you have may be correct, it seems a little high to me. A 'typical' ZenCart installation only has ~110 tables.

I use the import function in MyPhPAdmin in Cpanel to transfer this old database into new, but in trying several times to import into 1.5.4 database it still gives me the same result. My database is quite large so I am wondering if it is timing out or corrupting when uploading (even though I do not receive any error messages when doing this).

It is *possible* for either of this things to be occurring, but it is quite unusual that if this is the case you aren't seeing any error messages.

Is there an easier way to import my database using the Database Backup MySQL plugin that I have installed on my current 1.5.3.

Sorry, but I can't comment about this plugin. I've only ever used the phpmyadmin export/import method.

I will suggest that when you do the export (with phpmyadmin) that you select the option to compress the file, as this tends to take care of any timeout issues (the resulting files are up to 10times smaller). Also, if the files are compressed you'll avoid the possibility of any corruption with the import (unless the compressed file itself get corrupted, and if this does happen you'll be notified of the problem after the upload, but before any 'import' actually starts.

Would it be best to create another new database for v.1.5.4 than the one I have as it doesn't have all of the tables

Another of the phpmyadmin export options is "Add Drop Table". If you enable this, then when the import is taking place any pre-existing tables will be dropped and recreated prior to the actual data being imported, which effectively gives you a 'clean' database (in practical terms, this is almost the same as creating a new database).

I'm not sure if any of this helps or not.

Cheers
RodG