Exporting and importing between 2 mysql databases

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';