Exporting and importing between 2 mysql databases

This article has not been rated yet. After reading, feel free to leave comments and rate it.

Question:

Answer:

1. Create a second database, here called olddb
   
2. Assuming you have a SQL dump at hand, pass it to mysql. The backup script is called backup.sql below
   
3. Export the table to a local file (here: /Content/tmp/data.txt)
   
4. Leave this database and go back to your regular db
   
5. Do a LOAD DATA INFILE to restore your data (maybe empty that table first)

	mysqladmin -uroot -pPASS create olddb mysql -uroot -pPASS olddb <backup.sql mysql -uroot -pPASS olddb --> select * from MYTABLE into outfile '/Content/tmp/data.txt'; mysql -uroot -pPASS --> LOAD DATA INFILE '/Content/tmp/data.txt' INTO TABLE MYTABLE FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n';

Comments:

Email address (not necessary): Rate as Off-topic Very Helpful Helpful Ok article Not useful Very bad	Hide my email when showing my comment. Please notify me once a day about new comments on this topic. Please provide a valid email address if you select this option.
It seems that you are from Washington, US . Info/ Feedback on this	Show city and country Show country only Hide my location
Leave your comment here:
Please type in the code:
Add a picture: Please do not post inappropriate pictures. Inappropriate pictures include pictures of minors and nudity. The owner of this web site reserves the right to delete such material.