Copy MYSQL database from one machine to another

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

Showing Answers 1 - 2 of 2 Answers

soorajVs
Profile Answers 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 machine
Import the database to MysSQL server : mysql -u root -p < MyDatabase.sql

bagya
Profile Answers by bagya

Jul 31st, 2009

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