mysql export fields mapping

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
srdva59
Forum Commoner
Posts: 77
Joined: Sun Feb 15, 2009 10:58 am

mysql export fields mapping

Post 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
:)
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Re: mysql export fields mapping

Post 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.
(#10850)
Post Reply