Creating a backup copy of your MYSQL database, also known as database export, is simple! Go to your cPanel > phpMyAdmin, select the database you wish to export from the list on the left, then click on the Export option in the toolbox on top of the page.
To restore a backup copy, select the database you wish to import into and click on the Import option. Upload the backup from where you have saved it on your computer. And you are all set, as easy as that!