In this article I'll walk you through how easy it is to download a database backup of your MySQL database from within cPanel.

Backing up your website's database periodically is always a great thing to do, as someone who has lost data myself from failing to remember to back up, I can't stress enough how important it is to backup your database to save yourself stress down the road.

Almost every application that websites run off these days is powered by a back-end database. If some data goes missing in your database, either accidentally from removing things from within your application's administration section, or from database corruption or malicious activity, all of that stuff you've probably spent hours working on is gone for good in some cases when it's not in our daily backups any longer.

Anytime I'm getting ready to make any large changes to a site, upgrading to the latest version of a particular application, or I just got done with some great content posting, I go ahead and grab a local copy of my database backup for safe keeping.

Backup database in cPanel

  1. Login to your cPanel.
  2. cpanel click on backupsUnder the files section, click on Backups.
  3. cpanel backups click on database name to downloadNow under the Download a MySQL Database Backup section, click on your database name, in this case userna5_wordpress.
  4. windows file explorer viewing database backupGo to the folder your web-browser downloaded the database backup to, and you should now see the compressed .sql.gz file.

Now you'll have a good working copy of your database locally stored safely on your own computer. If you delete something by accident, or are having any other database problems, you can then restore your database from that good backup.

You will also more than likely be interested in learning about how to backup website files in cPanel, and restoring website files in cPanel now that you know how to backup a MySQL 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!

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
n/a Points
2014-09-29 5:29 pm

I don't see userna5_wordpress

 

I see 2 other files. One ends in something similar to my URL. The other ends in _wpdb.

 

What do I do with this?

 

Staff
17,273 Points
2014-09-29 5:52 pm
Hello Nathan,

Thanks for the question. The "userna5_wordpress" is simply an example name. If you want to backup the database, click on the name that you see in that location.

I hope this helps to answer your question. If you have any further questions, please let us know.

Regards,
Arnel C.
n/a Points
2014-09-29 6:20 pm

but there are 2 diffrent files

Staff
17,273 Points
2014-09-29 6:49 pm
Hello Nathan,

Yes, there 2 different files because you have 2 different MySQL databases on your account. This tutorial gives you directions for downloading a backup of a database file. If you want to obtain a copy of your database backup file, then click on each file name.

Regards,
Arnel C.
n/a Points
2014-09-29 6:59 pm

Do both files go to one website? Or does each file go to a seaprate website?

Staff
17,273 Points
2014-09-29 7:07 pm
Hello Nathan,

I took a close look at your files. If you ever want to know the actual database that your WordPress site is using, simply open the WP-CONFIG.PHP file in a text editor. You will see the database name there. According to the files I saw on your site, you have two WordPress sites. So the first database, goes to the site starting with the name "micro" and the other database goes to your primary domain site (the website used to name your account with us). I hope that's clear. You have TWO WordPress sites running on your account, and those databases are for each of your sites. Each file goes to a separate website.

Regards,
Arnel C.
n/a Points
2014-09-29 7:16 pm

ok thanks, ARN

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.

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