This plugin hasn’t been tested with the latest three major releases of WordPress. It may no longer be maintained or supported and may have compatibility issues when used with more recent versions of WordPress.

Database Sync

Description

WARNING: This plugin is for advanced users. If used incorrectly it could wipe out all your content!

Keeping databases in sync between development, staging and live servers can be a pain. This plugin lets you
link together several WordPress installations by sharing a secret token. Once linked, administrators can pull
or push the entire database between servers with just a click.

Currently syncs database only, not uploaded files.

Backups

The plugin will attempt to make local backups of the database before overwriting. These are stored as gzipped SQL
files in wp-content/plugins/database-sync/backups/dbYYYYMMDD.HHMMSS.sql.gz The backups directory should be made
writable, and you should keep an eye on it if you sync often as it will grow in size.

Usage

See Installation instructions.

Plugin by Outlandish

Installation

  1. Install as usual.
  2. Activate plugin.
  3. Repeat 1 & 2 on each server that you want to link.
  4. Go to Tools > Database Sync on the main server and copy the token.
  5. On the other server(s), go to Tools > Database Sync and paste the token.

You are now set up to pull from and push to the main server.

Reviews

31 January 2017
Not compatible with Multisite. A note should be added to the plugin description page saying as much. As soon as the description is updated accordingly, I'll remove this review. 🙂
10 October 2016
After trying 2 other db sync plugins that failed to work, I stumbled across this one. Simple to install and worked perfectly. Syncing is really quick as well, easily the fastest sync tool I have used.
3 September 2016
Is this wizardry? This plugin works so seemlessly it's amazing! I love that it pulls the ACF stuff as well which is a huge time saver. Another issue is the media uploads which this helps with as well. Simply sync up the two databases and then ftp your uploads and both db's are in perfect lockstep!
Read all 24 reviews

Contributors and Developers

“Database Sync” is open source software. The following people have contributed to this plugin.

Contributors

Translate “Database Sync” into your language.

Interested in development?

Browse the code, check out the SVN repository, or subscribe to the development log by RSS.

Change Log

Version 0.5.1

  • Extra URL sanitisation.

Version 0.5

  • Fixed XSS vulnerability.

Version 0.4

  • Support for dumping and syncing MySQL VIEWs.

Version 0.3.1

  • Fixed E_NOTICE warning. Thanks to miniragnarok.

Version 0.3

  • Use $wpdb instead of deprecated mysqli extension. Thanks to Simon East.
  • Fixed manual dump download filename. Thanks to Ronald Mansveld.

Version 0.2

  • Initial public release.

Version 0.1

  • Internal testing.