I have to migrate data from one MySQL database table to another MySql database table in a different MySql database. Most of the fields do not match data types and are not even in the same order. Even in those fields that do match, on occasion, the datatypes are completely different (varchar vs int, varchar vs char, int vs datetime, etc.).

I'm using MySQL version 4.1.12.

Does anyone have any suggestions as to the easiest way to do this.

Thanks in advance for any help you can give.