Free MySQL synchronization tool

Question

Hi, does anybody know some free tool for synchronization MySQL database (data and structure) like in Navicat for Windows ?

Answer 1

What functionality of Navicat do you need? There is a number of ways without that software to synchronize mysql. You can use the MySQL replication functionality or simply copy and paste the data files (if your using MyISAM tables it's just a straight copy) innoDB tables are a little more tricky.

Answer 2

If you just want synchronization would MySQL replication work for you?

http://dev.mysql.com/doc/refman/5.0/en/replication.html

Answer 3

Maatkit has a tool for this ....

http://www.maatkit.org/doc/mk-table-sync.html

Answer 4

I'm using Structure and Data synchronization. Sometimes Data transfer. I was just wondering if there is not any software like this for free. Found only HeidiSQL (which looks perfect but work worse).

Answer 5

you can check Nobhill's DB tools, all MySQL tools are for free, check RANDOLPH and the Database compare tool

EDIT : The compare tool used to be free, now its for 50$

Answer 6

Toad for MySQL has synchronization abilities and is free.

Answer 7

MySQL Workbench Beta does this perfectly and for free for now.

Answer 8

I need a free tool like sqlyog for linux. Can any one recommend me a good tool?