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. Bakcing up your database is easy to do in PHPMyAdmin. We'll show you how to backup your database using PHPMyAdmin and assume that you alreayd 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 similiar to the one below.
  2. PHPMyAdmin_1

  3. Click on the tab labeled "Export" at the top of the page.
  4. PHPMyAdmin_2

  5. Select your databases you wish to backup from the list on the left side and check the "SQL" radio button under the list.
  6. PHPMyAdmin_3

  7. Make sure the "Structure" box is checked as well as "Add if not EXISTS", "Add AUTO_INCREMENT value" and "Enclose table and field names with backquotes". These are typically checked by default.
  8. PHPMyAdmin_4

  9. Scroll down the page to the "Save as file" section. Select the compression you wish to use. This can be important is you have a large database to help you control the size of the file.
  10. PHPMyAdmin_5

  11. Click the "Go" button in the bottom right corner of the "Save as file" section.
  12. PHPMyAdmin_6

  13. Congratulations! You have now successfully backed up 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:
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

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!