How to take backup of MySQL Database
Using Site Backup & Restore - Select "Site Backup & Restore" from the Files category, after logging into cPanel. - Select "MySQL Database (Individual)" option. - Select the desired archive date. - Select the desired database. - Click "Download file" option on the right, or from the interactive mouse-over menu. Using phpMyAdmin - Login to your cPanel and click phpMyAdmin icon in Databases section. - Select the database you wish to export the backup from the drop-down list. - Click on the "Export" Tab. - Click the "GO" button.