How can I back up the database from cPanel & where is cPanel database backup stored by default? What file type is cPanel backup?
cPanel-Back up database
Collapse
Unconfigured Ad Widget
Collapse
X
-
There are 2 ways to backup your MySQL database:
cPanel Backup Wizard
phpMyAdmin
To backup MySQL database using the cPanel Wizard, follow these steps:- Sign in to cPanel using your Username & Password.
- Navigate to the Files section & select the Backup Wizard option.
- Click on the "Back Up" button to initiate the backup process.
- 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."
- 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.
- Sign in to cPanel using your Username & Password.
- In the DB section of the cPanel main page, locate and select phpMyAdmin.
- On the left column, click on the database name you want to back up.
- Click on the Export at the top of the page.
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.
Comment