Sync Two MySQL Databases

Sync Two MySQL Databases What is a good way to sync two MySQL databases?
Asked by: Guest \| Views: 223

Total answers/comments: 2

Comments display order:

Guest [Entry]

"Here are a couple of ideas:

Use Replication: http://www.howtoforge.com/mysql_database_replication
Use mysqldump in an import/export script to semi-automate it"

Guest [Entry]

"For a free and reliable one-off MySQL synchronization tool, check out Percona Toolkit (formerly Maatkit):

http://www.percona.com/doc/percona-toolkit/2.1/pt-table-sync.html"