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

  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.
Did you find this article helpful?

We value your feedback!

Why was this article not helpful? (Check all that apply)
The article is too difficult or too technical to follow.
There is a step or detail missing from the instructions.
The information is incorrect or out-of-date.
It does not resolve the question/problem I have.
How did you find this article?
Please tell us how we can improve this article:
Email Address
Name

new! - Enter your name and email address above and we will post your feedback in the comments on this page!

Like this Article?

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!