How to Make Database Backup in cPanel

Taking a Database Backup in cPanel is an important step to ensure that you can restore your website or data in case of an issue. Here’s a step-by-step guide to back up your database using cPanel

Steps to Take Database Backup

To take a database backup in cPanel hosting, follow these steps:

1. Log into cPanel

• Go to your domain’s cPanel login page (usually yourdomain.com/cpanel) and enter your credentials.

2. Access the “Backup” Tool

• Scroll down to the “Files” section and click on “Backup”.

3. Download a MySQL Database Backup

• In the “Download a MySQL Database Backup” section, you will see a list of your databases.
• Click on the database name that you want to back up. This will download a .sql file (or .gz file if compressed) to your computer.

4. Alternatively, Use “phpMyAdmin” for Database Backup

• Scroll down to the “Databases” section and click on “phpMyAdmin”.
• In phpMyAdmin, select the database you want to back up from the left sidebar.
• Click on the “Export” tab.
  • Export Method: Choose either:
    • Quick – Exports all tables in a simple format.
    • Custom – Allows you to select specific tables and additional export options (for advanced users).
• Choose the “Format” as SQL.
• Click “Go”, and the backup will be downloaded.

That’s it! You now have a backup of your database.

Conclusion

Taking a database backup in cPanel is straightforward. You can use either the Backup tool for a quick download or phpMyAdmin for more customization. Both methods allow you to securely save your database as an .sql file, ensuring that your data is safely backed up for future use.