How to Create a MySQL Backup

There are two ways to back up your MySQL databases. You can use the backup utility in your cPanel account or you can manually backup using phpMyAdmin.

To use the backup utility, do the following:

- Login to your cPanel and click Backup.
- On the left further down you will see the list of MySQL Databases.
- Select the one to backup. This will download a backup copy to your computer.

You now have a backup copy of your database.

To manually backup using phpMyAdmin follow these steps:

- Login to your control panel at www.yourdomain.com/cpanel 
- Click on 'phpMyAdmin' under the 'Databases' menu
- From the dropdown list to the left, choose the database you wish to export the backup from. 
- Click on the 'Export' Tab. 
- Click the 'Select All' link shown in blue, then tick the 'Save as file' box and 'Go'. 
-  You will be asked to save the .sql file to the hard drive, click 'Save'. 
- Choose the location to save to and click 'Save'. 

Your database has now been exported.
  • 2 Users Found This Useful
Was this answer helpful?

Related Articles

Modifying Fields in Database Tables with phpMyAdmin

The purpose of this tutorial is to teach you how to modify fields in database tables with...

How to Create a Database Username in cPanel?

1. Log into your cPanel account.2. In the "Databases" section, click on "MySQL Databases" Icon....

Exporting Databases and Tables with phpMyAdmin

This tutorial is to teach you how to export databases and tables with phpMyAdmin. We will assume...

How to rename a database in cPanel?

1. Log into your cPanel account.2. In the "Databases" section, click on "MySQL Databases" Icon....

How to create a database in cPanel?

1. Log into your cPanel account.2. In the "Databases" section, click on "MySQL Databases" Icon....