InMotion Hosting Support Center

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.

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


33,560 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.

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

but there are 2 diffrent files

33,560 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.

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?

33,560 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.

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

ok thanks, ARN

n/a Points
2014-11-10 2:19 pm

Is this an up-to-date backup, or is it one that has been ran prior?

24,082 Points
2014-11-10 2:46 pm
Hello Laura,

Thank you for your question. The file you download is up-to-date, and includes everything in the database at the time you download.

If you have any further questions, feel free to post them below.

Thank you,
n/a Points
2015-01-12 5:24 pm

Hello there,

Do you know of any way to AUTOMATICALLY backup MySQL database and send it over somewhere else safe periodically ?


Thanks for the help.

38,180 Points
2015-01-12 8:11 pm
Hello Anon,

We do not have a specific script set up for automatic backups for user use on an account. However, if you know how to code a little you can set up a cron job to automatically run a backup for you at desired intervals.

Kindest Regards,
Scott M
n/a Points
2015-04-20 1:56 pm



 My client is accidently upgrade the database and I dont have the Database Backup . How do I take the previous Database backup . Any idea thanks in advance

38,180 Points
2015-04-20 2:52 pm
Hello Shebin,

It is not possible to get a backup of the previous database now if one does not exist. However if you are one of our customers and the total account size is under 10GB, then we may have a backup for you. You will need to contact Live Support in order to see if they have one for you.

Kindest Regards,
Scott M
n/a Points
2015-12-16 9:08 pm

This has been most helpful. Not sure if my site crashed with new update or if I have been hacked but this is step one of my manual upgrade. Thanks for the very simple instructions ( I am very simple!!)

n/a Points
2016-02-13 12:22 pm

On my I have around 1 millions of product and database site goes over 1,503.73 MB what is the best to reduce the size? Do I need to create a separate database, even if I dow how can I connect to my php site? 

38,180 Points
2016-02-15 6:08 pm
Hello Anam,
There is little to do to minimize the size of a database with a million products. Separating the database would not reduce the total size of the files. You would also then need to develop code to connect to the second database and know when to do so.

Kindest Regards,
Scott M
n/a Points
2016-03-08 3:44 am

Please help

I accidentally deleted my database. How do I restote the database?

4,258 Points
2016-03-08 10:55 am
If you have a backup of your database you can restore it following the steps in this article.

Post a Comment

Email Address:
Phone Number:

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

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