MySQL sync
From Noah.org
Jump to navigationJump to search
This synchronizes two MySQL databases.
Get Maatkit.
mk-table-sync --execute --verbose u=USERNAME,p=PASSWORD,h=SOURCE_HOST,D=SOURCE_DB_NAME DESTINATION_HOST
# schema.txt is just {dbname}.{tablename} followed by newline db.table1 db.table2 db.table3
-- Thanks to Jon Delanders, MySQL Guru for pointing out this script