SitePoint runs through a few options that one can use to synchronize WordPress live and development databases. I’ve linked to some of these options before, but it’s nice to have them all conveniently together. The solutions discussed include WordPress-specific tools:
- WP Migrate DB Pro
- WP Sync DB
- WPSiteSync for Content
- Database Sync
- WordPress Importer
- SyncDB
- WP Staging
- WordPress GitHub Sync
- PushLive
- WP Stagecoach
as well as generic tools, such mysqldump, mysqlpump, rsync, and git.
Overall, it’s a pretty complete list of tools. The one I’d like to add though is WP CLI, which allows a great deal of automation when it comes to WordPress, including things like database imports and exports, post and option management, and more.