Migrating MySQL 3.23 to 4.1

I am changing to a new webhost for my site, and am having a database issue.

The old MySQL server is running version 3.23.58. The new server is running 4.1. When I try and import the old database tables into the new, nothing happens. It says that it imports successfully, but there are no tables showing up.

After looking around the web for info on this, I am wondering if I must install an old version of MySQL on my own machine, import the database, upgrade to 4.1, and then export a shiny new 4.1 compatable database from there...

I have also tried downloading the MySQL Migration tools. Unfortunatly I'm on a Mac and one of the 4 tools included, called Migration, is not available for the Mac.

Has anyone else had this issue?

Thanks,
Bryan

At the bottom of each CREATE TABLE statement is a line that says ENGINE=blahblah

Chances are that you'll need to change that to TYPE=blahblah in order to get it to import properly.

You might find it easier to export structure only into one file, make the fixes and import.
THen export data-only and import it onto the new server which now has the structure in place.

And a good host should be capable of doing this in a blink for you.

Well, I'm switching to Network Solutions. They seem like they should be capable of doing it, but after many phone conversations with a customer service rep, and having my issue sent up to "Engineering" I'm not so sure. There is no way to contact one of these "Engineers" directly, so I am planning on doing it myself.

I started importing each table individually, which worked pretty well. There are only two tables left that wont import...products_type_layout and products_description.

I will try the ENGINE to TYPE thing and try it again. Thanks for the help.

Bryan

I'm sure you have your reasons, but Network Solutions is an odd choice. Why pay so much more for the same features you could get elsewhere for typically less cost and more personalized and knowledgeable service?

Nevertheless, good luck with your imports.

Network Solutions was the clients choice. And from where the site was before, its a big improvement, and substantially lower in cost (This place was charging $140 a month). So we are where we are.

Import happened. I had to import each table separately, and had trouble with only the two tables I mentioned before. Switching the ENGINE to TYPE idea worked. Site is up. Thanks.

Thanks for the follow-up. Glad it's working!