# \[ANN\] MysqlTableSyncer 0.2

**URL:** <https://www.ruby-forum.com/t/ann-mysqltablesyncer-0-2/149235>\
**Category:** Rails\
**Created:** [September 22, 2008, 7:08pm UTC](https://www.ruby-forum.com/t/ann-mysqltablesyncer-0-2/149235 "2008-09-22T19:08:32Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![rogerdpack](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/45deac/32.png) [@rogerdpack](https://www.ruby-forum.com/u/rogerdpack)\
**Post date:** [September 22, 2008, 7:08pm UTC](https://www.ruby-forum.com/t/ann-mysqltablesyncer-0-2/149235/1 "2008-09-22T19:08:32Z")

</div>

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 🙂

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](http://code.google.com/p/ruby-roger-useful-functions/wiki/MysqlTableSyncer)  
for more details.

Feedback welcome.  
Thanks!  
-=Roger

---

<div class="post-metadata">

**Author:** ![rogerdpack](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/45deac/32.png) [@rogerdpack](https://www.ruby-forum.com/u/rogerdpack)\
**Post date:** [September 30, 2008, 10:08pm UTC](https://www.ruby-forum.com/t/ann-mysqltablesyncer-0-2/149235/2 "2008-09-30T22:08:02Z")

</div>

Roger P. 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](http://code.google.com/p/ruby-roger-useful-functions/wiki/TableSyncer)

Enjoy!  
-=R