---
title: How to create MySQL backup in cPanel
description: MySQL databases have a way to backup into sql files. These files ends with .sql extensions. .sql files can be used as a backup for your database and are portable. They can be restored anywhere on other MySQL databases seamlessly…
url: "https://truehost.com/support/knowledge-base/how-to-create-mysql-backup-in-cpanel/"
updated: "2024-06-07"
---

# How to create MySQL backup in cPanel

MySQL databases have a way to backup into sql files. These files ends with .sql extensions. .sql files can be used as a backup for your database and are portable. They can be restored anywhere on other MySQL databases seamlessly

Below are 2 ways of getting your database backup

## Using the Backup feature in cPanel

1.Login to cPanel

2. Go to Backup icon under Files section

![](https://truehost.co.ke/support/wp-content/uploads/2021/11/Screenshot-2021-11-05-at-23-49-17-cPanel-Main.png)

3.Click on the Databases listed, one at a time. They will prompt for download so you can save them locally

![](https://truehost.co.ke/support/wp-content/uploads/2021/11/Screenshot-2021-11-05-at-23-52-14-cPanel-Backup-1024x417.png)

## Using phpMyAdmin

1.Login to cPanel

2.Go to phpMyAdmin icon under Databases.

![](https://truehost.co.ke/support/wp-content/uploads/2021/11/Screenshot-2021-11-05-at-23-54-53-cPanel-Main.png)

3. From your left side, select the database you want to backup then click **Export** then **Go**

![](https://truehost.co.ke/support/wp-content/uploads/2021/11/Screenshot-2021-11-05-at-23-55-30-lim106-truehost-cloud-localhost-information_schema-phpMyAdmin-4-9-7-1024x486.png)

You will get a prompt to download a file which you should save n your computer. That file is your database backup.