Take the 2-minute tour ×

I have a maintanance problem synchronizing my MySQL data bases . These are the databases I have :

  1. My development DB : Here I make my curret development changes .
  2. Staging DB : I need to make all the changes I did in the development on it before using , currently I hold migration scripts for structure and data.
  3. Production DB : A production environment . Have to do exacly the same as the staging .

My problem , is sync. the structure , and some of the data. This is really a very hard work to maintaine. Is there any technics , tools to do with MySQL . What is replication , is it good for my situation , how to use it .

Thanks in advance ...

share|improve this question
Have you considered simply making dumps and importing them into the other databases? –  Pekka 웃 May 23 '10 at 8:33
I need to add only new things and don't delete or ovveride what exists . Also dumps still seems to me a manual way and need efforts to sync it with the current DB . –  Wasim May 23 '10 at 11:50
add comment

1 Answer

up vote 0 down vote accepted

The product that I have used for many years is Navicat MySQL edition. The program works well for both structure and data synchronization. You can do one-way or two-way synchronizations. The version I have is 7.2.10 and its main limitation is that it doesn't handle VIEWS, TRIGGERS, or STORED PROCEDURES. I am sure the newer versions do handle this.

share|improve this answer
add comment

Your Answer


