InMotion Hosting Support Center

When you export a database, you are creating a backup file of the database. This backup file is usually a .sql file (a text file), and can be used to copy and import the database onto another server. In this article we'll show you how to export your database.

  1. Log into phpMyAdmin

    If you are an InMotion Hosting customer: Log into your cPanel and click the phpMyAdmin icon under the Databases heading.

    If you are not an InMotion Hosting customer and do not use cPanel, please contact your hosting provider for more help.

  2. using-phpmyadmin-to-export-a-database Click the database you are working with in the left menu
  3. Click Export in the top menu
  4. Under the Export heading, ensure that all of your tables are selected and that the SQL option is selected.
  5. Under the Options heading, ensure that you have selected, Add DROP TABLE / VIEW / PROCEDURE / FUNCTION
  6. Ensure the Save as file option (towards bottom of page) is checked. If you think you database is quite large, choose either "zipped" or "gzipped" to compress the file so it will be easier to download. If you choose none, you will be save the file without compression (which is OK, you don't have to compress the file).
  7. Click Go
  8. You will be prompted to either open or save the file. Please select the option to save the file and then save the somewhere you'll remember (such as directly on your desktop).

    Congratulations, you have just exported a copy of your database!

Support Center Login

Social Media Login

Social Login Joomla

Related Questions

Here are a few questions related to this article that our customers have asked:
How to copy a large database
How do I see all files on my server.
Would you like to ask a question about this page? If so, click the button below!
Ask a Question
n/a Points
2015-08-24 8:51 am

Thanks for your valuable suggestion

n/a Points
2016-10-07 7:09 am

Easy to follow! 

After 3 days @ 1 call per day, This is exactly what I needed to begin with! With the youtube video skipping ahead (glitching)..... just wanted to say,

I can't thank you enough, Jeremy  

Post a Comment

Email Address:
Phone Number:

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

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