InMotion Hosting Support Center

Note: that you will require root access in order to follow these directions.

In this tutorial:

A very common task that's often involved in moving from one host to another is the migration of databases. There are two ways to export your database if you're using MySQL - through a client interface like phpMyAdmin or through the command line using SSH. We'll cover both methods in the steps below.

Exporting a Database with phpMyAdmin

  1. Login to WHM as the "root" user.
  2. Open phpMyAdmin. In WHM you can easily search by typing "phpmyadmin" in the search bar at the top left, and you'll see it appear in the menu.
  3. Click on the button labeled Databases.
  4. Select the Database you want to export.
  5. Click on the tab labeled EXPORT.
  6. We will be using the QUICK options and exporting in the SQL format. This means that you don't need to select any options. Just click GO in order to begin the export of the database. You will be required to select a location to save the file and name the saved file. Make sure you record this location as well as the name of the file so that you can find it later.

  7. For more information on phpMyAdmin, please see the official documentation.

Exporting a Database using the MySQL Command Line

  1. Login to SSH as the "root" user.
  2. Use the following command line:

    mysqldump -u username -p databasename > SQLfile-created-by-export.sql

    The table below breaks down the commands:

    Username This is the MySQL user assigned to the database
    DatabasenameThis is the name of the MySQL database
    SQLfile-created-by-export.sqlThis is the name of the SQL file created when the file is created

    Keep in mind that the location of your exported file will be based on where you specify the file location in the command, or, if you don't specify the location, based on where you actually run the command. Make sure that you record the location name of the file so that you can find it later.

Congratulations, now you know how to export databases from PHPmyAdminm and command line interface!

Was this article helpful?

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

Forum Login

You are NOT logged in. You can still browse our Support Center.

To participate within our Community Support Forum:

Post a Comment

Email Address:
Phone Number:

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?


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!