In this lesson, we will show you how to migrate our WordPress website. In this fictional tutorial we will migrate a from HostABC to InMotion Hosting. As to provide no downtime during the migration process , we will not update the nameservers  for, 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.

  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.

  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

  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.

You are viewing Section 2: Migrating your WordPress Database
Section 1: Intro to Migrating your WordPress Site Data
Section 3: Migrating WordPress Files
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 this article:
Email Address

new! - Enter your name and email address above and we will post your feedback in the comments on this page!

Support Center Login

Social Media Login

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
n/a Points
2014-08-10 7:20 am
I am now scared to move my site to inmotion. There are many placed for me to screw up and I may loose my site. I was hoping to find a host that could help me move the site to inmotion.
13,552 Points
2014-11-20 11:00 am
Hello John,

Thank you for contacting us. The article above is for people who want to migrate their own WordPress database.

We can help transfer your site, just submit a Website Transfer Request in AMP.

This will create a ticket with Live Support, and they will email you back upon completion of the transfer.

Thank you,
n/a Points
2014-11-20 1:03 am

Hi, I am traying to migrate my DB but I get the following error: 


SQL query:

-- Database: `*******_DB`



MySQL said: Documentation

#1044 - Access denied for user '*******'@'localhost' to database '*******_DB' Can you please advice how to fix this?

Thank you

13,552 Points
2014-11-20 12:14 pm
Hello Carlos,

Thank you for contacting us. If access is denied for your user, make sure you have attached the user to the database, and given them privileges to make changes.

If you have any further questions, feel free to post them below.

Thank you,
n/a Points
2015-02-06 4:41 pm

Hi there,

I'm having the same issue here and already checked everything 3x. Also deleted and created again the database but I just can't import, keep getting the #1044 error message.

Any idea what else could be?


11,156 Points
2015-02-06 6:58 pm
Could you provide the full error message?

Post a Comment

Email Address:
Phone Number:

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

6 Questions & Comments

Post a comment

Back to first comment | top

Need more Help?


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:
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!