Skip to content

Instantly share code, notes, and snippets.

@cmoa-webmaster
Last active November 12, 2019 15:02
Show Gist options
  • Select an option

  • Save cmoa-webmaster/4f88191ba6340345779dcb5c383e2594 to your computer and use it in GitHub Desktop.

Select an option

Save cmoa-webmaster/4f88191ba6340345779dcb5c383e2594 to your computer and use it in GitHub Desktop.

Revisions

  1. cmoa-webmaster revised this gist Nov 11, 2019. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion migrate-wordpress-database.md
    Original file line number Diff line number Diff line change
    @@ -7,7 +7,7 @@ Go to [deliciousbrains.com](https://deliciousbrains.com/signin/), login, and dow
    ## 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.
    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.

  2. cmoa-webmaster revised this gist Nov 11, 2019. 1 changed file with 6 additions and 15 deletions.
    21 changes: 6 additions & 15 deletions migrate-wordpress-database.md
    Original file line number Diff line number Diff line change
    @@ -7,24 +7,15 @@ Go to [deliciousbrains.com](https://deliciousbrains.com/signin/), login, and dow
    ## 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
    ```
    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
    ```
    Admin > Tools > Migrate DP Pro > Settings > Migrate.

    For Multisite installs: Network Admin > Settings > Migrate DB Pro > Settings > Migrate.

    ![image](https://user-images.githubusercontent.com/9203439/68615079-3b16ce80-04ba-11ea-8a2c-03425142699d.png)

  3. cmoa-webmaster revised this gist Nov 11, 2019. 1 changed file with 6 additions and 2 deletions.
    8 changes: 6 additions & 2 deletions migrate-wordpress-database.md
    Original file line number Diff line number Diff line change
    @@ -8,9 +8,13 @@ Go to [deliciousbrains.com](https://deliciousbrains.com/signin/), login, and dow
    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`.
    ```
    Admin > Tools > Migrate DP Pro > Settings
    ```
    For Multisite installs:
    `Network Admin > Settings > Migrate DB Pro > Settings`.
    ```
    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:
  4. cmoa-webmaster revised this gist Nov 11, 2019. 1 changed file with 8 additions and 4 deletions.
    12 changes: 8 additions & 4 deletions migrate-wordpress-database.md
    Original file line number Diff line number Diff line change
    @@ -8,15 +8,19 @@ Go to [deliciousbrains.com](https://deliciousbrains.com/signin/), login, and dow
    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`
    `Admin > Tools > Migrate DP Pro > Settings`.
    For Multisite installs:
    `Network Admin > Settings > Migrate DB Pro > Settings`
    `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`
    ```
    Admin > Tools > Migrate DP Pro > Settings > Migrate
    ```
    For Multisite installs:
    `Network Admin > Settings > Migrate DB Pro > Settings > Migrate`
    ```
    Network Admin > Settings > Migrate DB Pro > Settings > Migrate
    ```

    ![image](https://user-images.githubusercontent.com/9203439/68615079-3b16ce80-04ba-11ea-8a2c-03425142699d.png)

  5. cmoa-webmaster revised this gist Nov 11, 2019. 1 changed file with 6 additions and 4 deletions.
    10 changes: 6 additions & 4 deletions migrate-wordpress-database.md
    Original file line number Diff line number Diff line change
    @@ -8,13 +8,15 @@ Go to [deliciousbrains.com](https://deliciousbrains.com/signin/), login, and dow
    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, go to Network Admin > Settings > Migrate DB Pro > 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, go to Network Admin > Settings > Migrate DB Pro > Settings > Migrate.*
    `Admin > Tools > Migrate DP Pro > Settings > Migrate`
    For Multisite installs:
    `Network Admin > Settings > Migrate DB Pro > Settings > Migrate`

    ![image](https://user-images.githubusercontent.com/9203439/68615079-3b16ce80-04ba-11ea-8a2c-03425142699d.png)

  6. cmoa-webmaster revised this gist Nov 11, 2019. 1 changed file with 2 additions and 2 deletions.
    4 changes: 2 additions & 2 deletions migrate-wordpress-database.md
    Original file line number Diff line number Diff line change
    @@ -5,9 +5,9 @@ Copy your database from one WordPress install to another with one click from the
    Go to [deliciousbrains.com](https://deliciousbrains.com/signin/), 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 the suite of WP Migrate DB Pro plugins in your local WordPress plugins directory. These plugins need to be active on both sites.
    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:
    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, go to Network Admin > Settings > Migrate DB Pro > Settings .*

  7. cmoa-webmaster revised this gist Nov 11, 2019. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion migrate-wordpress-database.md
    Original file line number Diff line number Diff line change
    @@ -2,7 +2,7 @@
    Copy your database from one WordPress install to another with one click from the dashboard with [WP Migrate DB Pro](https://deliciousbrains.com/wp-migrate-db-pro/).

    ## Step 1: Get Plugin
    First, if you don’t already have copies of the **WP Migrate DB Pro** plugins, go to [deliciousbrains.com](https://deliciousbrains.com/signin/), login, and download the latest versions. **Account** info and **License Key** are available in **1Password**.
    Go to [deliciousbrains.com](https://deliciousbrains.com/signin/), 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 the suite of WP Migrate DB Pro plugins in your local WordPress plugins directory. These plugins need to be active on both sites.
  8. cmoa-webmaster revised this gist Nov 11, 2019. 1 changed file with 4 additions and 4 deletions.
    8 changes: 4 additions & 4 deletions migrate-wordpress-database.md
    Original file line number Diff line number Diff line change
    @@ -16,11 +16,11 @@ Admin > Tools > Migrate DP Pro > Settings
    Admin > Tools > Migrate DP Pro > Settings > Migrate
    *For Multisite installs, go to Network Admin > Settings > Migrate DB Pro > Settings > Migrate.*

    ![](connection-info.png)
    ![image](https://user-images.githubusercontent.com/9203439/68615079-3b16ce80-04ba-11ea-8a2c-03425142699d.png)

    - Set the permissions on the production site to **Pull** data.

    ![](089339B9-86EA-4B3B-80E0-23F5C17DD4AB.png)
    ![image](https://user-images.githubusercontent.com/9203439/68615267-a19bec80-04ba-11ea-8a30-540ec27c7a55.png)

    - Now, go back to the local install and paste the connection info:
    Admin > Tools > Migrate DP Pro > Settings > Migrate
    @@ -32,7 +32,7 @@ Note: you may get a warning about **“Different Table Prefixes”** that will n

    - Use Migrate DB Pro’s find and replace tools to replace the remote domain with the local domain.

    ![](F53B7CFB-F02E-4852-A863-730942C6D182.png)
    ![image](https://user-images.githubusercontent.com/9203439/68615126-57b30680-04ba-11ea-94ca-d6355b70c38e.png)

    - 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:
    @@ -46,7 +46,7 @@ Check over your settings, if everything looks in order, push the **“Pull”**

    Migrate DB Pro will launch a modal window detailing your migration progress and indicate any issues.

    ![](feature-progress.png)
    ![image](https://user-images.githubusercontent.com/9203439/68615138-5e417e00-04ba-11ea-84ec-66c3b49df614.png)

    Once complete, you will be forced out of the local WordPress admin. Login with the production credentials.

  9. cmoa-webmaster created this gist Nov 11, 2019.
    53 changes: 53 additions & 0 deletions migrate-wordpress-database.md
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,53 @@
    # Migrate WordPress Database
    Copy your database from one WordPress install to another with one click from the dashboard with [WP Migrate DB Pro](https://deliciousbrains.com/wp-migrate-db-pro/).

    ## Step 1: Get Plugin
    First, if you don’t already have copies of the **WP Migrate DB Pro** plugins, go to [deliciousbrains.com](https://deliciousbrains.com/signin/), login, and download the latest versions. **Account** info and **License Key** are available in **1Password**.

    ## Step 2: Install and Activate
    Install and activate the suite of WP Migrate DB Pro plugins in 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, go to 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, go to Network Admin > Settings > Migrate DB Pro > Settings > Migrate.*

    ![](connection-info.png)

    - Set the permissions on the production site to **Pull** data.

    ![](089339B9-86EA-4B3B-80E0-23F5C17DD4AB.png)

    - 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](https://wordpress.org/plugins/search-and-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.

    ![](F53B7CFB-F02E-4852-A863-730942C6D182.png)

    - 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

    ## 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.

    ![](feature-progress.png)

    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.