MySQL Database synchronization

views:

answers:

MySQL Database synchronization

Is there any free MySQL synchronization tool out there?

I need to synchronize the database structure across servers. Data synchronization is not necessary (but is a plus).

It needs to be free (for non commercial use), not a free trial.

Edit: None of the answers so far has worked, were free, or a suitable to my needs.

The only application i know that does this is Navicat for Mysql. It is fairly cheap, however it is not free :(

devians 2010-09-06 00:00:28

try with mysql replication (part of the mysql solution) if still isnt a option. you can make a script which send a "show create table" for each table and store the structure and replicate it in the new server(s)

Freaktor 2010-09-06 00:11:10

Simpler said than done, and replication is not an option

Petah 2010-10-12 10:04:52

echo 'show tables' | mysql mysql -ppassword -N | awk '{print "echo show create table " $1 "| mysql mysql -ppassword -N -E" }' | sh #change the database name from "mysql" and in the output remove the first two lines of earch table. and you get a file with the structure, also change the password

Freaktor 2010-10-14 15:41:10

There is a free tool that does this, it's called Mysql Workbench and they have a mac version. You need to reverse engineer your schema before synching..

Ricardo 2010-09-18 07:31:26

+1 A:

Try Daffodil Replicator, it is available in Open Source version as well. It is a Java tool for data synchronization, data migration, and data backup between various database servers.

Faisal Feroz 2010-09-18 07:42:03

Toad® for MySQL can do both a "Schema Compare" as well as a "Data Compare" (and a lot more).

By the way: the software is freeware - in case somebody asks.

Petah 2010-10-17 23:13:33

ansaurus

tags:

views:

answers:

MySQL Database synchronization

related questions