MysqlTableSyncer 0.2

rubyonrails-talk
1

Hi. Released a script recently to sync the contents of tables between two 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 :slight_smile:

Syntax: 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 database1

New in version 0.2: Now it can do a limited structure sync of different tables, as well, and perform an "entire database" sync.

See http://code.google.com/p/ruby-roger-useful-functions/wiki/MysqlTableSyncer for more details.

Feedback welcome. Thanks! -=Roger

2

Roger Pack wrote:

Hi. Released a script recently to sync the contents of tables between two different mysql databases. Syntax: ruby syncer.rb --from=database1 --to=database2 --tables=table_1,table_2

Released it as a gem, if any are interested gem install table_syncer

with updated instructions http://code.google.com/p/ruby-roger-useful-functions/wiki/TableSyncer

Enjoy! -=R