In this class, we will be walking you through the steps on how to migrate our fictional Wordpress site, my-wordpress-site.com, from HostXYZ to Web Hosting Hub. As we don't want any issues during the migration, we have not updated the namservers for my-wordpress-site.com, so the site is still pointing to the servers at HostXYZ. After we have completed the WordPress Site migration and testing, we'll then update the domain's nameservers and point them to Web Hosting Hub.

Export a Backup of your WordPress Database

Your WordPress database contains all of the content that you've written for your site. phpMyAdmin is an industry standard for managing MySQL database, and as so many hosts provide this tool to their users, we'll show you below how to use it to download a backup of your database.

Don't have phpMyAdmin?

wordpress_export

  1. At your old host, access phpMyAdmin
  2. Load your WordPress database by clicking the database name in the left
  3. Click "Export" at the top right.
  4. Under "Export", ensure that all tables are highlighted and that "SQL" is selected (these are the default settings)
  5. Under "Options", ensure 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.

When you click Go, you will be prompted to download the backup file.

Create a new MySQL Database

We'll want to import the database we just exported above, but we'll first need to create a blank database. To do so:

mysql_database_wizard

  1. Log into your Web Hosting Hub cPanel
  2. Click the "MySQL Database Wizard" link.
  3. In step 1 of the Wizard, enter a name for your database. You can call anything you want, such as wpress for example. Write this down somewhere.
  4. In step 2 of the Wizard, enter a database username and password. You can enter anything you want, such as wpuser. Write down your username and password somewhere.
  5. In step 3 of the Wizard, select "ALL PRIVILEGES" and click "Next Step"

Import the backup you just generated

Now that we've created a blank database, let's import our WordPress.

phpmyadmin_import

  1. Log into your cPanel at Web Hosting Hub
  2. Click the "phpMyAdmin" icon
  3. Select the database you just created by clicking the link in the left. In this example, I'll be clicking "_wpress".
  4. Click "Import" in the top right
  5. Click the "Browse" button and select the database backup file on your computer that you generated earlier
  6. Click "Go"

Congratulations, you just successfully migrated your WordPress database! Let's move on to our next step, migrating our WordPress application 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 our Help Center:
Email Address
Optional, but our team may contact you for more information.
Did you find this article helpful?

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.

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!

Help Center Search

Current Customers

Email: support@WebHostingHub.com Ticket: Submit a Support Ticket
Call: 877-595-4HUB (4482)
757-416-6627 (Intl.)
Chat: Click To Chat Now

Ask the Community

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

Not a Customer?

Get web hosting from a company that is here to help.