InMotion Hosting Support Center

In this article, we will show you how to migrate your customers' databases into your reseller hosting account. At this point, you should have already created a cPanel account.

How Do I Know if my Customers are using a Database?

If your customer is using a Content Management System like WordPress or Joomla, or they have a shopping cart, then they are most likely using a database to store the content of their website.

Repairing the Database

It is important to always "repair" the database before exporting. Often, exporting a database without using "repair" can cause data loss due to caching and various server-side functions.

How to Repair a Database in phpMyAdmin

phpMyAdmin is a popular open-source database management system. It is widely used, so your customers may have an available installation in their hosting environment. Here we'll show you how to access phpMyAdmin from the cPanel interface.

  1. Log into your cPanel.
  2. Click on phpMyAdmin located under the Databases category.
  3. Select the database you want to repair from the menu on the left side.
  4. Under the Table section choose Check All.
  5. In the dropdown menu, select Repair table.


How to Repair a Database from the Command Line

If your customer does not have either cPanel or phpMyAdmin, you can also repair the database on the command line using the below command:

mysqlcheck --repair -u [USERNAME] -p [DATABASE]

Make sure to replace [USERNAME] with the actual database username and [DATABASE] with the name of the database.

Exporting the Database

You will need a copy of the database in .sql format. Your customer should be able to provide this to you. If not, there are a few different ways they can export their database.

You can export a database using phpMyAdmin if available. You can also export the database on the command line.

Import the Database into Your Reseller Server

Once you have recovered the .sql file from the old host you can easily import the database into your customer's phpMyAdmin installation (available through cPanel).

How to Import the Database into phpMyAdmin

The steps below are meant to be followed after you have created a new database to import the original database into.

  1. Log into cPanel.
  2. Go to the Databases section.
  3. Choose phpMyAdmin.
  4. Select the database you created to import into.
  5. Click Import from the top menu.
  6. Under File to Import click Browse.
  7. Locate the database file you are importing.
  8. Click Go at the bottom.

Now that you have imported the database, make sure that any applications that use this database can connect successfully. Remember, you can test the site with a hosts file modification before switching DNS to your reseller server.

If you are working on migrating an account from a non-cPanel host, you can continue to our next article on transferring emails to your reseller account.

Support Center Login

Our Login page has moved, Click the button below to be taken to the login page.

Social Media Login

   
Social Login Joomla

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

Post a Comment

Name:
Email Address:
Phone Number:
Comment:
Submit

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

0 Questions & Comments

Post a comment

Back to first comment | top

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!