WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Before I embark on this tutorial from the WordPress Codex on mirroring a WordPress database from a remote server to a local one. I'd like to get some feedback from SE users who have successfully achieved this, or who have followed the same tutorial.

Here are my questions:

  1. What methods have you guys used to mirror/sync your databases?
  2. What kind of MySQL software do you use (or think is the most reliable), in terms of importing/exporting MySQL dumps
  3. Is there a risk of data loss during the transfer?
share|improve this question
this question has been asked a few times - have you searched here for previous answers? – anu May 29 '11 at 8:56

Database synchronization between dev/staging and production

Easily Move a WordPress Install from Development to Production?

Maintaining synced staging/production WP sites

share|improve this answer
thanks, the second link is extremely helpful. Though my 2nd and 3rd questions still stand, those links barely scratched surface. I'm currently using MySQL Workbench, which I'm really happy with, but configuring it to the right settings can be confusing, at least to my level knowledge. I was just wondering if there's any risk (even if its miniscule) of data loss when exporting MySQL dumps from a remote server. – VicePrez May 29 '11 at 21:23

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.