Trouble updating database

[NWCE]

Hi Dr.Byte,

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.

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).

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. When I change my config files to point to the new database and then try to access admin area before running zc_install to update the database I get the 0071 error.

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, and I wouldn't get the 0071 error?

Sorry for what may seem like and elementary question, but I appreciate the help!

Kind regards,
Jeff

[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

[NWCE]

Hi Rod,

Thanks for your reply and help. I actually export a zipped database from the Backup MySQl plug in I have installed in Zen cart. As for the number of tables, I got this number from MyPHP Admin, when I look at my v.1.5.3 database and scroll to the very bottom, it shows 250 tables. I am not sure why this would be such a vast difference from the 110 that you suggested.

Thanks again for your help,

Jeff

[NWCE]

Hello again,

I have tried deleting my new v.1.5.4 database in MySQL and then creating a new one and tried Importing in the old v.1.5.3 database into this v.1.5.4 one using PHPMyAdmin Import. After it completes, I still only get 160 tables and when looking in MySQL Databases in Cpanel to look at the size....my current v.1.5.3 is 232 Mb and my v.1.5.4 is only 200Mb.

Still stumped as to why it is not importing the entire database.

Does anyone have any other suggestions?

Thanks in advance,

Jeff

[mc12345678]

Hello again,

I have tried deleting my new v.1.5.4 database in MySQL and then creating a new one and tried Importing in the old v.1.5.3 database into this v.1.5.4 one using PHPMyAdmin Import. After it completes, I still only get 160 tables and when looking in MySQL Databases in Cpanel to look at the size....my current v.1.5.3 is 232 Mb and my v.1.5.4 is only 200Mb.

Still stumped as to why it is not importing the entire database.

Does anyone have any other suggestions?

Thanks in advance,

Jeff

If you export your "new"database, is the size the same as the export of the old database? Might not be the import process, but instead the export process that is changing things.

[NWCE]

Hi mc12345678,

Thanks for your reply and suggestion. The export process that I am using is from a Zen Cart plugin Backup My SQL, and I have done a couple today, to insure it wasn't being corrupted during the process.

The biggest thing I see in my "new" database is the tables only go down to "Paypal" and then no other tables are importing after that, even though when I look at my old database they are all there. I have tried doing a check database in Cpanel, and all items say OK. Not sure why the remaining tables are not being imported in.

Any ideas?

Thanks again,

Jeff

[mc12345678]

Hi mc12345678,

Thanks for your reply and suggestion. The export process that I am using is from a Zen Cart plugin Backup My SQL, and I have done a couple today, to insure it wasn't being corrupted during the process.

The biggest thing I see in my "new" database is the tables only go down to "Paypal" and then no other tables are importing after that, even though when I look at my old database they are all there. I have tried doing a check database in Cpanel, and all items say OK. Not sure why the remaining tables are not being imported in.

Any ideas?

Thanks again,

Jeff

So, with that in mind, there are a few things possible here. The tables that have not been transferred over, do they start with the same prefix as the tables that are transferred?

160 tables is a great number of tables more than a default install that even has several other modifications associated...

The default install has just under 100, so something has added at least 60 tables to your database.

So in answer to teh question of any ideas, well thinking that the backup program is doing what it is expected to do which would be to backup the database information applicable to your store and that the remaining tables are not so associated because they do not fit the parameters... Just my thought on the matter when using this method of backup and without further information.

The other part of it, and if I remember correctly is associated with your issue is that perhaps there is a timeout occurring that is killing the process too early. Perhaps could copy the backup file, edit it to remove the first set(s) of tables and try to upload just the remaining tables.