How can I backup the database from cPanel

Backing up your MySQL database regularly is one of the most important things you can do to protect your website. Whether you are making changes to your site, migrating to a new host, or simply keeping a safety copy, cPanel provides multiple ways to download a backup of your database. This guide covers the recommended methods and what to do when things go wrong.

Method 1: Using the Backup Wizard (Recommended)

The Backup Wizard is the simplest way to create a database backup. It works well for databases up to a few hundred megabytes.

1. Log in to your cPanel account.
2. In the Files section, click on Backup Wizard.
3. Click Backup.
4. Select MySQL Databases.
5. Choose the database you want to back up from the dropdown list.
6. Click Generate Backup. The file will download automatically as a .sql.gz archive.

Method 2: Using phpMyAdmin Export

phpMyAdmin gives you more control over the export format and is useful when the Backup Wizard is unavailable or not working.

1. In cPanel, go to Databases and click phpMyAdmin.
2. Select your database from the left sidebar.
3. Click the Export tab at the top.
4. Choose Quick format for a full backup, or Custom to select specific tables.
5. Click Go. The file will download as .sql.

Method 3: Command Line via Terminal (SSH)

For large databases (500 MB+), the command line is the most reliable method because it avoids browser timeout limits entirely.

1. Connect to your server via SSH.
2. Run the following command:
   mysqldump -u dbusername -p dbname > backup.sql
3. Enter your database password when prompted.
4. Optionally compress it: gzip backup.sql

Important Notes

• Backup files are not stored on the server — they download directly to your computer. Keep them in a safe location (external drive, cloud storage).
• The .sql.gz file from the Backup Wizard can be restored through the Restore option in the same wizard.
• We recommend keeping at least 3 recent backups before making major changes to your site.
• cPanel full backups (available under the Backups icon) include your database along with all files, emails, and settings.

Troubleshooting

• "The backup file is too large to download" / download times out: This is the most common issue with databases over 50–100 MB. Switch to the phpMyAdmin method and use Custom export to split into tables, or use the SSH method above. If you do not have SSH access, contact support and we can generate the backup server-side for you.
• phpMyAdmin shows "No tables found in database": This means the database is empty or you selected the wrong database. Check the database name in cPanel → MySQL Databases.
• "Access denied" when using mysqldump: Make sure you are using the correct database user (not your cPanel username). You can find the database user in cPanel → MySQL Databases → Current Databases.
• Cannot find Backup Wizard: Some hosting plans use the Backups icon instead (also in the Files section). Both work the same way for database backups.
• "Proxy Error 502" or blank page in phpMyAdmin: This usually means the database server is temporarily overloaded. Wait a few minutes and try again. If it persists, open a support ticket.

Need help with a database backup? Contact our support team and we will assist you.