---
title: How to Download and Restore a MySQL Database Backup
description: "🌐This guide is also available in Arabic[← اقرأ بالعربية](https://kb.tarweig.com/docs/%d9%83%d9%8a%d9%81%d9%8a%d8%a9-%d8%aa%d9%86%d8%b2%d9%8a%d9%84-%d9%88%d8%a7%d8%b3%d8%aa%d8%b9%d8%a7%d8%af%d8%a9-%d9%86%d8%b3%d8%ae%d8%a9-%d8%a7%d8%ad%d8%aa%d9%8a%d8%a7%d8%b7%d9%8a%d8%a9-%d9%84%d9%82/) ### How to download a MySQL Database Backup The cPanel backup interface allows you to generate and download a backup of your MySQL databases. Backing up your website’s database periodically is…"
url: "https://kb.tarweig.com/en/docs/download-restore-mysql-database-backup/"
updated: "2026-10-11"
category: "Hosting Management / Backups & Restores"
---

# How to Download and Restore a MySQL Database Backup

🌐This guide is also available in Arabic[← اقرأ بالعربية](https://kb.tarweig.com/docs/%d9%83%d9%8a%d9%81%d9%8a%d8%a9-%d8%aa%d9%86%d8%b2%d9%8a%d9%84-%d9%88%d8%a7%d8%b3%d8%aa%d8%b9%d8%a7%d8%af%d8%a9-%d9%86%d8%b3%d8%ae%d8%a9-%d8%a7%d8%ad%d8%aa%d9%8a%d8%a7%d8%b7%d9%8a%d8%a9-%d9%84%d9%82/)

### How to download a MySQL Database Backup

The cPanel backup interface allows you to generate and download a backup of your MySQL databases. Backing up your website’s database periodically is always recommended, as it can save you from a lot of pain in case anything happens with your data. It is often necessary to take a backup (or “dump”) of an entire database management system along with all databases and tables, including the system databases which hold the users, permissions, and passwords.

**1)** [Log into cPanel](https://kb.tarweig.com/en/docs/login-cpanel-whm-account/).

**2)** Look for the “**Files**” section and click on the **“Backup” **icon.

![mysql backup cpanel](https://kb.tarweig.com/wp-content/uploads/kb-media/misc/full_backup_cpanel.png)

**3)** In the **“Partial Backup”** section under “**Download a MySQL Database Backup “** click on your database name you want to backup, in this case, it’s **chemiclo_demo**and the download will start automatically.

**![cpanel mysql backup](https://kb.tarweig.com/wp-content/uploads/kb-media/misc/cpanel_mysql_backup.png)**

A copy of the database will now to saved on your PC, and you should now see the compressed .sql.gz file in the folder your web-browser downloaded it.

### How to restore a MySQL Database Backup

If your database is corrupted or you have removed some useful data,  restoring the database from a previous working backup might be a great option to save the day. Luckily this can easily be done by following the next steps:

**1)** [Log into cPanel](https://tarweig.com/kb/how-to-login-into-your-cpanel-whm-account/a7/).

**2)** Look for the “**Files**” section and click on the **“Backup” **icon.

**3)** In the **“Partial Backup”** section click the “**Choose File**” button located under “**Restore a MySQL Database Backup “**  and select the backup file you want to use from your PC and click “**Open**“.

 

![cpanel restore mysql backup](https://kb.tarweig.com/wp-content/uploads/kb-media/misc/cpanel_restore_mysql_backup.png)

**4)** Now the name of the backup file you selected should be displayed, please double check that this is the right backup and click “**Upload**“.

![restore mysql backup cpanel](https://kb.tarweig.com/wp-content/uploads/kb-media/misc/restore_mysql_backup.png)

**5)** A new tab will open showing you information about the restore process.

![restore mysql backup](https://kb.tarweig.com/wp-content/uploads/kb-media/misc/restore_mysql_backup2.png)