1. Locate the link to your cPanel (Control Panel) from your web host, such as HostGator.com.
2. Login with your username and password.
3. Scroll down to about the tenth category called “Databases.”
4. Click on “phpMyAdmin.”
TO DOWNLOAD A BACKUP OF ALL DATABASES IN ONE FILE
5a. Click on “Export.”
6a. Wait for Databases to appear after the loading prompt.
7a. Under “Export Method” click on “Custom.”
8a. Under “Database(s)” click on “Select All.”
9a. Scroll all the way down and click “Go.”
10a. Choose “Save As”
11a. Choose location on your computer storage device or external storage device.
12a. Click “Save.”
13a. Verify database was properly downloaded and backed-up.
TO DOWNLOAD A BACKUP OF A SINGLE DATABASE IN ONE FILE
5b. Make sure you are at the “Home” location of your phpMyAdmin utility, if not locate and click on the house/home icon on the top left corner.
6b. Click on “Databases.”
7b. Choose the database you wish to download a backup copy of by clicking on the database name.
8b. Click on “Export.”
9b. Under “Export Method” click on “Custom.”
10b. Under “Database(s)” click on “Select All.”
11b. Scroll all the way down and click “Go.”
12b. Choose “Save As”
13b. Choose location on your computer storage device or external storage device.
14b. Click “Save.”
15b. Verify database was properly downloaded and backed-up.
Discussion Topic: How to Create a Database Backup in cPanel (Control Panel) using phpMyAdmin
