Import Database error

[paulclane]

Oh clever Zenners, please Help!
I have created a new test site for my online shop with a different hosting company. My old hosting was on an old legacy server and this company wanted me to move my Zencart shop to a new server, but they used a ZEUS web server, which didn't work very well.
So my test site installed beautifully with the new host. I am now in the process of uploading images, categories, etc, and I have totally renamed the admin folder to a Looooooooooong secret name. I never really got the hang of using custom file over rides, although I did try many times, but it never worked properly for me, so I will have to spend AGES comparing old an new php pages. I don't mind, but would have much preferred if the overrides worked for me. I wish a Zen Master would write a complete, idiot-proof, guide to overrides. I know there are a few guides out there, but they aren't as clear as I would have liked. And yes, I bought the book too!
Anyway, sorry for the blathering on, here is my problem: I tried to import the database from my old shop, (1.3.7), to my new shop, (1.3.9h), it fails at the first hurdle. It says: SQL query:Table structure for table `zen_address_book. DROPTABLEIFEXISTS`zen_address_book. (MyPHPAdmin 2.11.9.5. MySQL Client 5.0.83).
Well, the old database and the new database have different names and I presume this is the problem. My host won't let me create a DB name thet matches the old one. So, what do I do? any help please would be greatly appreciated!!!

[DrByte]

I tried to import the database from my old shop, (1.3.7), to my new shop, (1.3.9h), it fails at the first hurdle.

First, you should ALWAYS go from same-version-to-same-version, never try to upgrade when changing servers.

If you're moving servers, use the SAME version on the new one as you had on the old one.
Then, once you've got it working on the new one, upgrade the site to the latest version.

OR upgrade on the old server BEFORE moving to the new server. Test that your upgrade works fine on the old server, and THEN move to the new server.

Never try to do both steps at the same time. They're completely different activities.

It says: SQL query:Table structure for table `zen_address_book. DROPTABLEIFEXISTS`zen_address_book. (MyPHPAdmin 2.11.9.5. MySQL Client 5.0.83).

Apart from the fact that there should be spaces between DROP TABLE IF EXISTS, there's nothing wrong with what you've quoted there.

Well, the old database and the new database have different names and I presume this is the problem.

Zen Cart doesn't care about *database* names being different, because you simply tell it the database name to use.
You're probably confusing the "zen_" DB_PREFIX with the database name.
Just use the same prefix on the destination server as you had on the old server. (ie: step 2a of the tutorial)
https://www.zen-cart.com/tutorials/i...hp?article=100

[paulclane]

Thanks for taking the time to reply!

Should I delete the new 1.3.9h and put 1.3.7 on the new server?

The datebase import stops dead at:
DROPTABLEIFEXISTS`zen_address_book
after about 20 seconds.

This point is moot, if I'm deleting 1.3.9h.

The prefix is zen on both DBs

[DrByte]

Should I delete the new 1.3.9h and put 1.3.7 on the new server?

As I said before, it's best to have matching versions when switching servers.
Do keep in mind that v1.3.7 is not compatible with PHP 5.3 or newer.

The datebase import stops dead at:
DROPTABLEIFEXISTS`zen_address_book
after about 20 seconds.

I'm not surprised since DROPTABLEIFEXISTS is invalid syntax. If that's what's in your SQL backup file, you're in trouble.

[paulclane]

I have taken weekly DB backups. My old site is still live and I can take a backup anytime. Why would I have the zen_address_book. DROPTABLEIFEXISTS error? and how do I resolve it?

[DrByte]

I've never seen it written like that before.
How exactly are you doing your DB backups?

[paulclane]

I do my backups using MyPHP Admin, with all the specified boxes ticked, as recommended in the Zen support tutorials.

Can't I get anything right when it comes to Zencart?

[DrByte]

(MyPHPAdmin 2.11.9.5. MySQL Client 5.0.83).

That's a pretty old version of phpMyAdmin. Perhaps an update would be appropriate, given that v2.11 is end-of-life.
http://www.phpmyadmin.net/home_page/news.php

[paulclane]

I read the EOL yesterday and I wasn't very happy. I am moving from one hosting company to another because of the problems I am having with Zencart and Moodle sites, and now I find that the new host has old PHP!

[DrByte]

http://www.zen-cart.com/index.php?ma...es&pages_id=10