How to create mysql database backup in Cpanel, Website Backup

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 !

Mysql Database Backup
Mysql Database Backup

Comments 1 comment

hotwebideas profile image

hotwebideas 5 years ago from New York

probyte2u, Great hub and voted up. I needed to know hwo to do backups in cpanel, so you answered a few questions.

I am now following you, but I have many hubs on web design as well if you are interested in reading them.

    Sign in or sign up and post using a HubPages Network account.

    0 of 8192 characters used
    Post Comment

    No HTML is allowed in comments, but URLs will be hyperlinked. Comments are not for promoting your articles or other sites.


    Click to Rate This Article
    working