This article will give you a step by step guide on how to backup your database from your cPanel control panel (linux).
This article guide you backup then restore your database via system.
Sign into your cPanel and follow these steps:
1. Click Backups
2. Under Download a MySQL Database Backup, click on the database you would like to download
3. Your backup with now be downloaded
This now concludes how to backup your database using cPanel
Once you have a backup, if you ever inadvertently lose your data, then you can restore the database easily and quickly.
To restore a database, please do the following:
1. Login to your control panel and click Backups.
2. Click the Browse button next to the option which says Restore a MySQL Database.
3. Select the .sql.gz file which you want restored.
4. Click the Open button and click the Upload button.
Your database driven website should be working again.