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 Quote 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? Quote 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 Quote 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. Quote Link to comment https://forums.phpfreaks.com/topic/254010-mysql-export-fields-mapping/#findComment-1302692 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.