cPanel-Back up database

[zayn_william]

How can I back up the database from cPanel & where is cPanel database backup stored by default? What file type is cPanel backup?

[Annie_P]

There are 2 ways to backup your MySQL database:

cPanel Backup Wizard
phpMyAdmin

To backup MySQL database using the cPanel Wizard, follow these steps:

1. Sign in to cPanel using your Username & Password.
2. Navigate to the Files section & select the Backup Wizard option.
3. Click on the "Back Up" button to initiate the backup process.
4. In the cPanel interface, you can choose between a "Full Account Backup" or an "Individual Backup" for various components such as the Home Directory, MySQL Databases, Email Forwarders, and Filters. Select the option for "MySQL Databases."
5. You will find a list of MySQL Databases. To download backups, click on the name of the desired database, and the system will initiate the download of the selected MySQL Database backup.

To backup MySQL database using phpMyAdmin, follow these steps:

1. Sign in to cPanel using your Username & Password.
2. In the DB section of the cPanel main page, locate and select phpMyAdmin.
3. On the left column, click on the database name you want to back up.
4. Click on the Export at the top of the page.

In most cases, the Quick setting is recommended as it provides the optimal export configuration for MySQL backups. However, the Custom setting helps exclude specific tables, rename the exported file, or perform more advanced configurations.

To export multiple databases simultaneously, open phpMyAdmin and click on the Export tab without selecting any specific database in the sidebar.

By performing this action, the MySQL database will be saved to your local computer. It is highly recommended to have a local copy as a backup. Nonetheless, please remember that the file size can be significant, mainly if the database contains numerous tables and rows.