How to migrate Mediavine Create to a new site

This has come up enough that I wanted to document this process. Mediavine does not provide a JSON or XML export process so it is up to us to migrate it manually. These migrations almost always happen for me when I am taking recipes from the live site and moving them to the staging site where I am re-doing someones theme.

Easy Way (~$50)

Live site:

  • Purchase WP DB Migrate PRO (not an affiliate link)
  • Install and add serial number on your live site.
  • Click Migrate
  • Click Export Database
  • Tables – Export only selected tables below:
    • wp_mv_images
    • wp_mv_nutrition
    • wp_mv_products
    • wp_mv_products_map
    • wp_mv_relations
    • wp_mv_reviews
    • wp_mv_revisions (optional?)
    • wp_mv_settings
    • wp_mv_shapes
    • wp_mv_supplies
      • (basically wp_mv_*)
  • Post Types – Export only post types selected below
    • mv_create
  • Leave advanced options alone
  • Custom Find & Replace
    • For the URL and install folder put in your staging URL formatted like it is on the plugin page, the easiest way to get this is from the plugin installed on your staging site.

Staging Site:

  • Install and add serial number this should not count against your installs if it is setup as a staging site.
  • Migrate – REPLACE THIS SITE WITH ANOTHER SITE – Import Database
  • Choose the sql.gz file you created from the live site.
  • Backup the database before running the import
    • The easiest is a full backup
    • the simplest is to backup just what you are replacing.
  • Standard Find & Replace
    • If you did this right before it should look like how your site is setup.
  • Custom Find & Replace
    • If you have not done your find and replace properly now is the chance to replace the URL and install location.

FAQ:

What about my images?

For your images I personally do a tools-export-wordpress-media to get an XML of the URL’s and have that import onto the live site.

What about the posts associated with the cards?

Tools – export – posts and select the date range. Or you can use wp db migrate pro again!

What is the free advanced way?

Backup both sites first and then use phpMyAdmin and export the above listed tables from your live site. On your staging site then drop those tables and re-import the sql.gz of those tables to have the latest data. You will still need to migrate the image files as well.

Apps and settings I install on a new Ubuntu WSL Install [Updated January 2018]

Much cleaner than my old script! See instructions below.

The Simple One Liner

cd ~/ && wget https://gist.githubusercontent.com/wormeyman/3be8fa7243ca9afa73cb/raw/a74e65625119fadb4b8bff6cede0c0b40a57c2bb/setupWormeymanEnviro.sh && chmod +x ./setupWormeymanEnviro.sh && ./setupWormeymanEnviro.sh

The Full Process:

  1. Click View Raw
  2. cd ~/
  3. wget the raw file url
    1. https://gist.githubusercontent.com/wormeyman/3be8fa7243ca9afa73cb/raw/a74e65625119fadb4b8bff6cede0c0b40a57c2bb/setupWormeymanEnviro.sh
  4. chmod +x setupWormeymanEnviro.sh
  5. ./setupWormeymanEnviro.sh
  6. Unlikely but:
    1. If you receive an error you may have to enable the universe repository.
      1. First, open software center.
      2. Click on 'edit
      3. Then 'software sources'
      4. Check the box that says, "Community-maintained free and open-source software (universe)."
      5. If it asks you to reload you can say yes if you want but you will just reload again with the script so i usually just say close.

How to install LinSSID on Ubuntu 12.04

I needed to do a network survey the other day to see if wifi was working as expected and I decided to use my Ubuntu laptop for the purpose, I ran into this handy tool called LinSSID that allows you to do a wireless survey. The reason I am using Ubuntu 12.04 is that I feel that the LTS releases are the most stable and have the broadest install base so that is what I tend to use on my computers.

  1. Install LinSSID from it’s download page.
  2. After it is installed I found that I got an error stating that it could not see any wireless devices so I installed IW by typing the following command into the terminal[shell]sudo apt-get install iw[/shell]
  3. I was then able to run LinSSID by typing[shell]sudo linssid[/shell]

    in the terminal.

  4. (optional) If you would like to try combining steps 2.1 &3 try[shell] sudo apt-get install iw && sudo linssid[/shell]

Let me know in the comments if it works!