The WP Sync DB simplifies the work of migrating a WordPress database. With WP Sync DB we can copy our database from one WordPress install to another with a single-click in your dashboard. Very handy for syncing a local development database with a live site.
WP Sync DB
WP Sync DB eliminates the manual work of migrating a WP database. Copy your DB from one WP install to another with a single-click in your dashboard. Especially handy for syncing a local development database with a live site.
WP Sync DB exports your database as a MySQL data dump like phpMyAdmin, does a find and replace on URLs and file paths, then allows you to save it to your computer, or send it directly to another WordPress instance. It is perfect for developers who develop locally and need to move their WordPress site to a staging or production server.
WP Sync DB lets you choose which DB tables are migrated. Have a huge analytics table you’d rather not send? Simply deselect it and it won’t be synced.
Pull: Replace a Local DB with a Remote DB
If you have a test site setup locally but you need the latest data from the production server, just install WP Sync DB on both sites and you can pull the live database down, replacing your local database in just a few clicks.
Push: Replace a Remote DB with a Local DB
If you’re developing a new feature for a site that’s already live, you likely need to tweak your settings locally before deploying. Once you’ve perfected your configuration on your development machine, it’s easy to send the settings to your production server. Just push to the server, replacing your remote database with your local one.
Database Export & Backup
Not only can WP Sync DB pull and push your DB: it can export your DB to an SQL file that you can save and backup wherever you want. No need to ssh into your machine or open up phpMyAdmin.
All data is sent over SSL to prevent your database from being read during the transfer. WP Sync DB also uses HMAC encryption to sign and verify every request. This ensures that all requests are coming from an authorized server and haven’t been tampered with en route.
Automatic Find & Replace
When migrating a WordPress site, URLs in the content, widgets, menus, etc need to be updated to the new site’s URL. Doing this manually is annoying, time consuming, and very error-prone. WP Sync DB does all of this for you.
Stress Tested on Massive Sites
Huge database? No prob. WP Sync DB has been tested with tables several GBs in size.
Detect Limitations Automatically
WP Sync DB checks both the remote and local servers to determine limitations and optimize for performance. For example, we detect the MySQL
max_allowed_packet_size and adjust how much SQL we execute at a time.
Sync Media Libraries Between Installations
Using the optional WP Sync DB Media Files addon, you can have media files synced between installs too.
FREE WordPress plugin that lets you push, pull, and sync databases
You can save yourself a couple of quids – download here for free on github
Thank you for seeing my tutorial and feel free to share and comment :). Do you have a code snippet or tutorial and you want to see it published on my site? I will be more than happy to do it, please send me a message (here)