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.