Copy your database from one WordPress install to another with one click from the dashboard with WP Migrate DB Pro.
Go to deliciousbrains.com, login, and download the latest versions of the plugin. Account info and License Key are available in 1Password.
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.
- 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 production WordPress tables.
- 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
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.