How do I migrate data data from mysql-3.x to mysql-5.x?

cogagni
cogagni used Ask the Experts™
on
I'm trying to migrate a dumped data from mysql-3.23 to mysql-5.0 but I'm having numerous syntax errors. Please help.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
I had a similar problem with migrating data from mysql to informix, luckily IBM had a migration toolkit for me. And lucky for you, there is one called MySQL migration toolkit.

http://dev.mysql.com/doc/migration-toolkit/en/index.html

The doc will explain installation etc.

Author

Commented:
migration toolkit didn't worked for me. It exited abnormally without error after establishing connection from Target and Source. More help pls.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial