How to create mysql database backup file in cpanel

To save yourself from virus and trojan problem, one way to do it is to create back up files for your website. You should backup your home directory, mysql database, Email forwarders configuration and Email filters configuration.


By having back up files, it will help you to restore your wesbite back fast after it was hacked by virus or hackers. I had a terrible experience of Trojan problem, luckily got back up files to restore the site back.


The step to create mysql database backup file in cpanel is as stated below. Another way is to use Backup Wizard in Cpanel.


Step 1: Login to your Cpanel control panel


Step 2: Scroll below to Database


Step 3: Click on phpMyAdmin hyperlink


Step 4: On the left menu of phpMyAdmin, choose the database you wish to export the backup from.


Step 5: Click on the Export Tab.


Step 6: Click the Select ALL link shown in blue. The check Save as file and click GO.


Step 7: You will be asked to save the .sql file to the personal computer, select the folder and Click Save.


Step 8: Your database has now been exported.


Open your database file and verify the data is correct. Done !