ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel
  • »
  • Technology»
  • Internet & the Web

How to create mysql database backup in Cpanel, Website Backup

Updated on November 25, 2010

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


    0 of 8192 characters used
    Post Comment

    • hotwebideas profile image

      Bruce Chamoff 6 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.