Difference between revisions of "MySQL sync"
From Noah.org
Jump to navigationJump to search (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=...) |
m |
||
Line 2: | Line 2: | ||
[[Category:MySQL]] | [[Category:MySQL]] | ||
− | This synchronizes | + | This synchronizes two MySQL databases. |
Get [http://maatkit.sourceforge.net Maatkit]. | Get [http://maatkit.sourceforge.net Maatkit]. |
Latest revision as of 13:45, 9 February 2010
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