Backing up / Restore not working

[recentcoin]

Go to your old hosting provider and try downloading the SQL export as a zip file.

Then try uploading that (without unzipping) to your new hosting provider.

Your ultimate problem is the 0 queries executed. That means it didn't do anything. You may also want to check "drop if exists" in the export options.

[jstewart30]

Thank you for the suggestions. I tried both ZIP and GZIP, with no change (still 0 queries executed). I don't see a "drop if exists" export option...I've attached a screenshot of the export options I see in this phpMyAdmin version.

Is it correct that I should be Importing into a fresh ZC database? Or should I be going into a completely empty mySQL database? I think I've tried both, with no improvement, but I just want to make sure I'm approaching this from the right angle at least. And should it matter if the tables' names are different ("zen_tablename" versus just "tablename")? I tried renaming the first table from "zen_address_book" to just "address_book" to see if it would at least put data in that table, but it didn't.

Thanks.

[DrByte]

And should it matter if the tables' names are different ("zen_tablename" versus just "tablename")?

You want to keep the table names the same between sites ... otherwise you'll have trouble finding the actual data. You can rename them all manually, but that is best done AFTER importing, if you feel you must bother with it.

You should read the FAQ article on how to move between hosts: https://www.zen-cart.com/tutorials/i...hp?article=100