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

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

Using phpMyAdmin

1.Login to cPanel

2.Go to phpMyAdmin icon under Databases.

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

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