InMotion Hosting Support Center

If you have a website running a shopping cart or it is built with WordPress, Joomla or one of the many other content management systems it's likely you have a MySQL database. It is important to backup a copy of your database on a regular basis, often times this is a hard lesson to learn because it is too late. Backing up your database is easy to do in PHPMyAdmin. We'll show you how to backup your database using PHPMyAdmin and assume that you already know how to log into cPanel. If you need assistance with cPanel please review our article on How to log into cPanel

How to Backup your Database

  1. Once you have logged into cPanel, click on the icon "PHPMyAdmin" in the databases section. Once you have done that you should see a screen like the one below.
  2. PHPMyAdmin_1

  3. Select the database you wish to export by clicking on the box next to the database name as indicated in the graphic below.
  4. PHPMyAdmin_2

  5. Click on Export in the menu at the top of the phpMySQL screen. This will bring up the options for export and also give you a confirmation of where the export is coming from.
  6. PHPMyAdmin_3

  7. We are using the Quick export method. This exports the file in SQL format. If you need to select specific options for the export, then click on Custom and select your options. You should only select this if you are familiar with exporting MYSQL databases. Click on Go to complete the export.
  8. Click on Go to start export

  9. You will see a screen that asks where you want to save the export file. You also have the option to name the database backup file. When you save the file, make sure that it is saved to a safe location once the export is complete.
  10. Select the location for the backup

  11. Congratulations! You have now successfully backed up your database.
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

Support Center Login

Our Login page has moved. Please click the button below to be redirected to the login page.

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!