In this lesson, we will show you how to migrate our WordPress website. In this fictional tutorial we will migrate a your-wordpress-site.com from HostABC to InMotion Hosting. As to provide no downtime during the migration process , we will not update the nameservers  for your-wordpress-site.com, so the hosting will remain pointed to the previous host, in this case HostABC. Once we have performed the migration and tested the site, we will then update the domain's nameservers and point them over to InMotion Hosting. 

Exporting a Backup of your WordPress Database

The way WordPress works is all of your content that you have written for your website is stored in your database. phpMyAdmin is a hosting industry standard for managing MySQL databases, and many hosts provide this tool for their users to use. Since this tool is widely available, we will show you how to use phpMyAdmin to downlaod a backup of your existing database.

wordpress_export
  1. At your previous host, access phpMyAdmin.
  2. Load your WordPress database by clicking the database name in the left hand menu pane.
  3. Click the "export" tab at the top right.
  4. Under "export, highlight all the tables and select "SQL". These are the default settings.
  5. Under "options" make sure that "add DROP TABLE/ VIEW/ PROCEDURE/ FUNCTION" is selected.
  6. Ensure that "Save as File" towards the bottom of the page is selected.
  7. Click Go

This is prompt you to download the backup file.

Creating a NEW MySQL Database

To be able to import the database you just exported from your previous host, you will first need to create a blank database.

mysql_database_wizard
  1. Log into your cPanel account with InMotion Hosting.
  2. Click the "MySQL Database Wizard" link.
  3. In Step 1 of the Wizard, enter a name for your new databse. You can name your database whatever you would like, just be sure to write this down somewhere for future reference.
  4. In Step 2 of the Wizard, enter a database username and password. You can enter anything you would like as the user, please make a note of the username and password for future reference.
  5. In Step 3 of the Wizard, select "ALL PRIVILEGES" and click "Next Step"

Importing the Backup you Created

phpmyadmin_import
  1. Log into your InMotion Hosting cPanel account.
  2. Click on the "PHPMyAdmin" icon.
  3. Select the database you just created.
  4. Click "Import" in the top right.
  5. Click the "Browse" button and select the database backup file on your computer that you created earlier.
  6. Click "Go"

You have now completed migrating your WordPress database, congratulations! The next step in the process is to migrate your WordPress application files.

Please check the next article on Migrating WordPress Files. If you missed our previous article, please see the Migrating your WordPress Site Data tutorial. For more information on this course please visit Migrating your Existing WordPress site to InMotion Hosting.

Please check the next article on Testing your WordPress website after Migration. If you missed our previous article, please see the Migrating WordPress Files tutorial. For more information on this course please visit Migrating your Existing WordPress site to InMotion Hosting.

Did you find this article helpful?

We value your feedback!

Why was this article not helpful? (Check all that apply)
The article is too difficult or too technical to follow.
There is a step or detail missing from the instructions.
The information is incorrect or out-of-date.
It does not resolve the question/problem I have.
How did you find this article?
Please tell us how we can improve our Support Center:
Email Address
Optional, but our team may contact you for more information.
Like this Article?

Post a Comment

Name:
Email Address:
Comment:
Are you a bot?
Submit

Please note: Your name and comment will be displayed, but we will not show your email address.

Write New!
Do you want to publish a tutorial to our support center?

News / Announcements

SSL Certficate Warnings
Updated 2014-04-14 11:34 am EST
Hits: 2189
Heartbleed 0-day OpenSSL security bug
Updated 2014-04-14 04:43 pm EST
Hits: 5600

Related Questions

Here are a few questions related to this article that our customers have asked:
Ooops! It looks like there are no questions about this page.
Would you like to ask a question about this page? If so, click the button below!
Ask a Question

Need more Help?

Search

Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!