How to copy database from one machine to another machine in MYSQL? Explain with an example?

bagya

 Profile Answers by bagya Questions by bagya

• Jul 31st, 2009

Select * from information_schema.tables where TABLE_SCHEMA='test 'into outfile'D:backuptest_backup.sql';

soorajVs

 Profile Answers by soorajVs Questions by soorajVs

• Mar 6th, 2008

Make a dump of the database to be copied : mysqldump -u root -p --databases --opt MyDatabase > MyDatabase.sql
Copy MyDatabase.sql to the second machineImport the database to MysSQL server : mysql -u root -p < MyDatabase.sql

Answer Question  Select Best Answer