MySQL sync

From Noah.org
Revision as of 13:43, 20 December 2007 by Root (talk | contribs) (New page: Category:Engineering Category:MySQL This synchronizes two two MySQL databases. Get [http://maatkit.sourceforge.net Maatkit]. <pre> mk-table-sync --execute --verbose u=USERNAME,p=...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search


This synchronizes two 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