[Cialug] Merging MySQL databases

[Nathan C. Smith]

I have two databases from a program I use and two different versions.

I want to merge the data from the old database into the new database.  The Fields are almost the same but I'm not sure what tools I should use to do this.

Are there better ways/tools than phpMyAdmin to dump the old data out of the old database, map the correct fields in the new database and import the data?

Thanks for any pointers

-Nate