Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I'm looking for recommendations on the best way to copy data between locate and live deployments. I've just installed MYSQL work bench but can't see how to copy data from local to remote. Also in the MSSQL world there are useful tools like Data Compare that help with synchronisation. Is there a good quality equivalent in the mysql world.

share|improve this question
    
One-time copy? (mysqldump) Constant synchronization? (cluster) –  ptman Nov 17 '10 at 9:58

3 Answers 3

Along with MySQL dump there are tools like sqlyog that allow you to sync (not just import) both the schema and the data. I use this at when some of our OTE databases get out of sync with production.

share|improve this answer

mysqldump is a truly fantastic tool. It simply generates a script of all the create table statements along with insert statements for all the data. From memory it also generates the table create scripts in the same order (unlike SQL Server) - so you can use a simple side-by-side text comparison program such as Araxis Merge to compare the differences.

share|improve this answer

I would recommend using MYSQLDUMP. It's incredibly powerful and customizable. Here's a good link on how to perform a dump & move (otherwise known as a copy): LINK

Good luck.

share|improve this answer

Your Answer

 
discard

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.