Migrate Database
Copy your database from one WordPress install to another with one click from the dashboard with WP Migrate DB Pro.
Check out the new guide to migrating your entire WordPress site from the fine folks at DeliciousBrains.
Step 1: Get Plugin
Go to deliciousbrains.com, login, and download the latest versions of the plugin. Account info and License Key are available in 1Password.
Step 2: Install and Activate
Install and activate all WP Migrate DB Pro plugins to your local WordPress plugins directory. These plugins need to be active on both sites.
New installations will need the plugin license key. Copy the key from 1Password and paste in the plugin’s settings: Admin > Tools > Migrate DP Pro > Settings.
For Multisite installs: Network Admin > Settings > Migrate DB Pro > Settings.
Step 3: Connect
Once the plugins are installed and activated, go to the production website’s admin to copy the connection info: Admin > Tools > Migrate DP Pro > Settings > Migrate.
For Multisite installs: Network Admin > Settings > Migrate DB Pro > Settings > Migrate.
Set the permissions on the production site to Pull data.
Now, go back to the local install and paste the connection info:
Admin > Tools > Migrate DP Pro > Settings > Migrate
Choose “Pull”
Paste connection info
Note: you may get a warning about “Different Table Prefixes” that will need to be resolved before continuing. Use phpMyAdmin or use a Search & Replace plugin to amend the local database.
Use Migrate DB Pro’s find and replace tools to replace the remote domain with the local domain.
Check the Tables menu to include only the needed tables.
Which tables you need will depend on whether you are looking to migrate a multisite or a single site. Incremented table prefixes indicate that the installation is set up as a multisite.
If this is the first time setting up a local version of this particular site, download Media, Theme, and Plugin files:
Check Media Files
Check Theme Files
Check Plugin Files
Save Migration Profile - include a meaningful name
Note: Table prefixes can be randomized or use the default WordPress wp_ convention. Random prefixes offer some improved security.
Step 4: Pull Database
Check over your settings, if everything looks in order, push the “Pull” button at the bottom of the page.
Migrate DB Pro will launch a modal window detailing your migration progress and indicate any issues.
Once complete, you will be forced out of the local WordPress admin. Login with the production credentials.
You should be all set. Check over the site and make sure everything is in order.
Last updated
