From: Michael Guterl <mguterl@...>
Date: 2008-09-23T03:56:13+09:00
Subject: Re: [ANN] MysqlTableSyncer 0.2

On Mon, Sep 22, 2008 at 12:59 PM, Roger Pack <rogerpack2005@gmail.com> wrote:
> 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 :)
>
> 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.
>
It would be great if you could package this as a gem.

This sounds really useful.

Thanks!
Michael Guterl