# \[ANN\] MysqlTableSyncer 0.2

**URL:** <https://www.ruby-forum.com/t/ann-mysqltablesyncer-0-2/149237>\
**Category:** Ruby\
**Created:** [September 22, 2008, 7:07pm UTC](https://www.ruby-forum.com/t/ann-mysqltablesyncer-0-2/149237 "2008-09-22T19:07:48Z")\
**Posts on this page:** 6\
**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:07pm UTC](https://www.ruby-forum.com/t/ann-mysqltablesyncer-0-2/149237/1 "2008-09-22T19:07:48Z")

</div>

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 22, 2008, 9:05pm UTC](https://www.ruby-forum.com/t/ann-mysqltablesyncer-0-2/149237/2 "2008-09-22T21:05:05Z")

</div>

On Mon, Sep 22, 2008 at 12:59 PM, Roger P. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
wrote:

> It will show you a diff of the tables and/or optionally sync them so

It would be great if you could package this as a gem.

This sounds really useful.

Thanks!  
Michael G.

---

<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, 9:36pm UTC](https://www.ruby-forum.com/t/ann-mysqltablesyncer-0-2/149237/3 "2008-09-22T21:36:16Z")

</div>

Hi Roger,

Roger P. wrote:

> Released a script recently to sync the contents of tables between two  
> different mysql databases.

Nice! I took a look and posted a little feedback at the link provided.  
Looking forward to trying it out!

Best regards,  
Bill

---

<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:05pm UTC](https://www.ruby-forum.com/t/ann-mysqltablesyncer-0-2/149237/4 "2008-09-30T22:05:52Z")

</div>

Michael G. wrote:

> > It will show you a diff of the tables and/or optionally sync them so
> 
> It would be great if you could package this as a gem.

All righty released it as a gem.

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

---

<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:** [October 1, 2008, 11:48pm UTC](https://www.ruby-forum.com/t/ann-mysqltablesyncer-0-2/149237/5 "2008-10-01T23:48:23Z")

</div>

really cool. Waiting for oracle version…

2008/9/30 Michael G. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)

---

<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:18pm UTC](https://www.ruby-forum.com/t/ann-mysqltablesyncer-0-2/149237/6 "2008-09-30T22:18:57Z")

</div>

On Tue, Sep 30, 2008 at 4:04 PM, Roger P. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
wrote:

> [Google Code Archive - Long-term storage for Google Code Project Hosting.](http://code.google.com/p/ruby-roger-useful-functions/wiki/TableSyncer)
> 
> Enjoy!  
> You rock!

Thanks!  
Michael G.