MySQL Bugs: #42479: Migration Tool has error migrating data

Bug #42479	Migration Tool has error migrating data
Submitted:	30 Jan 2009 14:13	Modified:	4 Feb 2009 13:26
Reporter:	Will Barbee	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Migration Toolkit	Severity:	S2 (Serious)
Version:	5.1.30	OS:	Windows (XP SP3)
Assigned to:		CPU Architecture:	Any
Tags:	migration tool data 5.1.30

Description:
I am trying to use the Migration Tool program to migrate my data from MySql 4.0.14a to MySQL 5.1.30. 

I defined the two new databases using Create Database commands. I defined the two old databases as well. I copied the old data under the old database creations. 

When I run the Migrate Tool, it runs fine thru Initialization and Direct Migration and I chose MySQL for the databases being migrated. For the Source Schemata display, I chose one of the databases to be converted. The program started Reverse Engineering and gave an error immediately: 
"ERROR - Could not be Reverse Engineered - ...Fcn ReverseEngr() returned error: 
Could not execute SHOW TABLE" 

How can I migrate my 4.0.14a databases to 5.1.30? 

WillB

How to repeat:
I will attach my old data under the new database to this note.

Do you really want to migrate or just to upgrade?

I have to migrate the data as it is a running application.
Thus, I need to move the data from the 4.0.14a format into the 
databases at 5.1.30.

WillB

We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

MySQL migration tool is not made for older MySQL versions then 5.0.

Also I think what you are looking for is MySQL upgrade and not migration. Please look here for more informations about upgrading:

http://dev.mysql.com/doc/refman/4.1/en/upgrade.html
http://dev.mysql.com/doc/refman/5.0/en/upgrade.html
http://dev.mysql.com/doc/refman/5.1/en/upgrade.html

The most safest way is to use mysqldump and dump your data and restore them into 5.1. 

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.

Thanks, Suzanne.

As I said, I put it on the Migration Forum but got no responses.

I understand that I have to dump/restore the data.

WillB