Home » Questions » Computers [ Ask a new question ]

Sync Two MySQL Databases

Sync Two MySQL Databases

What is a good way to sync two MySQL databases?

Asked by: Guest | Views: 55
Total answers/comments: 2
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"