Migrate Quiz and Survey Master to a New WordPress Site

Written by
Kyler Boudreau
on December 7, 2018

Are you moving to a new WordPress site and noticing that there’s no easy way to migrate your Quiz and Survey Master data? The good news is a single FREE plugin will do everything you need to migrate the data from one site to another.

Install the ARI Adminer Plugin

The ARI Adminer database manager allows you to easily export and import data from your WordPress database. It’s easier than phpMyAdmin and the server command line. Just search for “ARI Adminer” in the WordPress plugin directory and install it. This will allows you to move all of your Quiz and Survey Master data.

*Advice: Backup your database first. We recommend iThemes BackupBuddy.

 

Export Quiz and Survey Master Data

The first step in migrating your Quiz and Survey Master data is to export their tables via ARI Adminer. Quiz and Survey Master tables begin with wp_mlw and wp_wp_pro. If this sounds confusing, don’t worry. It’s easy!

Run the ARI Adminer tool against your WordPress database. Basically just accept the defaults and run the tool. Click Export in the top left of the tool. Leave the export settings at default except for the output. Change this to GZIP. If you don’t, the import will probably fail. Then select all of the tables and their data (two checkmarks) that begin with wp_mlw and wp_wp_pro. This is your Quiz and Survey Master data.

*Note: If your WordPress database uses something other than wp_ for table prefix, just look for the mlw and wp_pro tables with your prefix.

Prep New Site for Import

You need to install Quiz and Survey Master on your new site (same version as old site) and then ARI Adminer. Run the Adminer tool, find all of the _mlw and _wp_pro tables in the main screen and drop them. Then choose import on the left, and import your GZIP file under the File Upload section.

BOOM! That’s it! However, let’s say your WordPress site uses a different table prefix. Follow the next step:

Change the Table Names

In Adminer simply click on the table itself, click the alter table link, and then change the table name to the new database prefix in the Table Name field.

Now jump over to Quiz and Survey Master and you’ll see all of your old data.

Congrats! We told you migrating Quiz and Survey Master from one site to another was a walk in the park. Thanks for reading, and please refer Outer Gain to any business needing an online marketing solution.

Kyler Boudreau
Written By
Kyler Boudreau

Kyler is the co-founder of Outer Gain, and the founder of Theater Eleven Pictures and Follow Hook: The Network Marketer’s CRM. He lives with his wife and daughter on the island of Kauai.

Would you like us to send you the latest?
[contact-form-7 404 "Not Found"]

Leave a Reply

Your email address will not be published. Required fields are marked *

Upload your logo here. If you don't have a logo, you can create a simple one for free at the following site: https://logomakr.com/. We have a video in OGU that talks about creating a logo. It's a short video, so if you're new to logos, we recommend you check it out. Have fun!

This allows you to place an image or solid color underneath your home page logo and menu. See an example of this type of layout at followhook.com.

If you would like to change the background color of your site, you can do that here! If you want to set it back to the default color, the color code is #FFFFFF.

Optional: only change this if you don't like the default. You can enter any manual pixel setting in here (ie 1200px) or you can enter 100% for a full width top.

This will add space on the left side. Normally you don't need space on the left, but in case you do, this is the place! The setting is in pixels. The default is '0.'

This adds space on the top, above your logo. The default is 15.

This will add space on the right side. Normally you don't need space on the right, but in case you do, this is the place! The setting is in pixels. The default is '0.'

This adds space on the bottom, below your logo. The default is 15.

This defines how wide your logo is. This setting is in pixels.

px

When using the wide navigation, you can opt to have your logo centered or left aligned. *Note: if using a top search field, you can only left-align.

This defines how wide your logo is on a tablet in wide view (varies by device).

%

This defines how wide your logo is on a tablet in normal view (varies by device).

%

This defines how wide your logo is on a normal sized mobile phone in normal view (varies by device). The setting is a percentage.

%

This defines how wide your logo is on a large mobile phone in normal view (varies by device). The setting is a percentage.

%

This will position the top of your site at the top at all times, even with scrolling. *Note: This only works with the small menu setting.

Choose a color for the border.

This setting is in pixels. We recommend 1.

When you visit a website, your browser tab shows a tiny icon for the site. If you're not sure on this, go visit http://outergain.com and you'll see ours. You can upload an image for your site's favicon here. *Note: you must use a square image and the image type must be a PNG. If you use a JPG or GIF it may not work. Please visit http://support.outergain.com if you have questions.

This will place a search form on the top right of your site for computer screens only. *Note: You will need to adjust the 'Navigation Top Margin' of your menu under 'Site Menu' or the search field will appear directly behind the navigation.

Change to zero for no border.

Choose the background color for the footer form field. The default is #FFFFFF.

Choose the background color for the footer form button. The default is #AAAAAA.

Choose the background color for the footer form button with mouseover.

Choose the font color for the footer form button. The default is #444444.

This is the size of the font on the button. The setting is in pixels.

This sets the spacing in pixels above the search form.

px

This sets the spacing in pixels to the right of the search form.

px





Do NOT follow this link or you will be banned from the site!