Hi. Released a script recently to sync the contents of tables between
different mysql databases.
The need for this is mostly as a faster, open source replacement to
Navicat [to those who have used it] or SQLyog – since you can sync on
the command line it’s faster
ruby syncer.rb --from=database1 --to=database2 --tables=table_1,table_2
It will show you a diff of the tables and/or optionally sync them so
that the contents of database2’s table_1 and table_2 will match
New in version 0.2:
Now it can do a limited structure sync of different tables, as well, and
perform an “entire database” sync.
for more details.