jason213123 Posted December 29, 2011 Share Posted December 29, 2011 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 Link to comment https://forums.phpfreaks.com/topic/254010-mysql-export-fields-mapping/ Share on other sites More sharing options...
Muddy_Funster Posted December 30, 2011 Share Posted December 30, 2011 couldn't you just migrate it and then use ALTER TABLE to change the name? Link to comment https://forums.phpfreaks.com/topic/254010-mysql-export-fields-mapping/#findComment-1302602 Share on other sites More sharing options...
jason213123 Posted December 30, 2011 Author Share Posted December 30, 2011 hi, no because the fields name are diferent and i need repeat this steps for others databases that is working 24 / day thanks Link to comment https://forums.phpfreaks.com/topic/254010-mysql-export-fields-mapping/#findComment-1302683 Share on other sites More sharing options...
SergeiSS Posted December 30, 2011 Share Posted December 30, 2011 You may try the next algorithm... It will work for any DBs, even when they a placed at different places. 1. Copy your data into file. "SELECT ... INTO OUTFILE" will help you. 2. Copy files to another server, if needed. 3. Load data from file to another database, use "LOAD DATA INFILE". At this step you may load info to a columns with any name. Check syntax for these commands in the MySQL help. Link to comment https://forums.phpfreaks.com/topic/254010-mysql-export-fields-mapping/#findComment-1302692 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.