Page 1 of 1

mysql export fields mapping

Posted: Thu Dec 29, 2011 4:23 am
by srdva59
hi,
i have two databases and each one have diferent fields names and tables
and i want a creat a map for each field and each table and export to a database to the other
i have tested the mysql migration but i can“t choose a diferent table in the destination
database.
any one know a software that does this?
thanks a lot for your help
:)

Re: mysql export fields mapping

Posted: Thu Dec 29, 2011 3:10 pm
by Christopher
You might want to try SELECT INTO OUTFILE and then LOAD DATA INFILE. Both are very fast and are useful for migration if you can use a file as an intermediate. And you can SELECT the fields in the same order as the target database, so the import works correctly.