Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

We have many website with Development , Staging and Production Server. we have many developers for many projects, we need a solution to synchronize the database with developer database with staging database. after that one is works we can move to live database.

That one is need to be fully automatically synchronize so that developer dont need to run that tool each and every time

share|improve this question
1. I did not understand your question, what you want is data from Dev_server to Stagging_Server, does the same apply to the other way? Stagging_Server to Dev_server ? 2. when you finish your development you want to have the data from Stagging_Server to be loaded on Production server once, is that correct? –  altmannmarcelo May 15 '13 at 10:18
You can synchronize through "SQLYog Ultimate Tool" Tools->SQLyog Database Synchronization Wizard-> (source) & (Target)->One-way-synchronization or two-way-synchronization –  Md Haidar Ali Khan Feb 1 at 12:31

1 Answer 1

use replication master=> slave ? be carefull of conflict

share|improve this answer
You should add more detail. Perhaps how to do the replication at a high level, or point to some documentation sources, etc. –  Max Vernon Apr 15 '13 at 14:20

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.