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:
- What methods have you guys used to mirror/sync your databases?
- What kind of MySQL software do you use (or think is the most reliable), in terms of importing/exporting MySQL dumps
- Is there a risk of data loss during the transfer?
Database synchronization between dev/staging and production
How to: Easily Move a WordPress Install from Development to Production?
Maintaining synced staging/production WP sites