Migrate MailPoet from One Site to Another

Written by
Kyler Boudreau
on September 7, 2018

Are you moving to a new WordPress site and noticing that MailPoet data doesn’t show as an option in the WordPress export tool? Don’t worry, it’s relatively painless to do.

Oddly, MailPoet doesn’t provide a way to easily move their data (at least in MailPoet 2). This would be a nice feature, but the good news is a single plugin will do everything you need. Let’s get to it!

Install the ARI Adminer Plugin

The ARI Adminer plugin allows you to quickly move data in and out of your WordPress database. It’s easier than phpMyAdmin and definitely easier than the server command line! The author is ARI Soft. We used it on an untested version of WP with no issues.

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

 

Export MailPoet Data

The first step in migrating your MailPoet data from one site to another, is to export MailPoet tables via ARI Adminer.

Run the ARI Adminer tool and accept the defaults. Click Export in the top left of the window. Then leave the export settings at default except for the output. Change this to GZIP. If you don’t, the import of the data to the new site will error out.

Now select all of the tables and their data (two checkmarks) that begin with wp_wysiga_. This is your MailPoet data.

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

Prep New Site for Import

You need to install MailPoet on your new site (same version as old site) and then ARI Adminer. Run the Adminer tool, find all of the _wysija 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 MailPoet and you’ll see all of your old data.

Congrats! We told you migrating MailPoet 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!