How do I backup MySQL?

If your website uses a MySQL database it is important you take regular backups of your database(s). If you are running an ecommerce or similair site where content is regularly being updated it is recommended to take a backup of your database daily.

To backup your databases, first log in to your cPanel:

http://www.yourdomain.com.au/cpanel

Once logged in, in the middle of the page click on Backups

In the Partial Backups section of the Backups Page, click on the database name underDownload a MySQL Database Backup to download a zip file to your computer containing the database. This file can then easily uploaded and restored by you at a later date if needed.


Restoring MySQL Backups

To restore a MySQL backup file you have on your computer, on the Backups page, under Restore a MySQL Database, click on Choose file.

A window will pop up and you can find and select the MySQL backup file, it will have a filename similair to dbname.sql.gz. Then click Upload. Once you click on the Upload button it will pop up a new window and the restore process will start.


For more details about cPanel backups you can visit the official cPanel site:http://etwiki.cpanel.net/twiki/bin/view/AllDocumentation/CpanelDocs/BackUps

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How do I backup my site?

To backup your website, or parts of it (Home Directory, MySQL etc) first log in to your cPanel:...

How do I use the File Manager?

From within cPanel you can access your online File Manager. This allows you to manage the...

How do I create a MySQL database and user?

Below is a guide to creating a MySQL Database. MySQL databases are used by many web applications...

How do I administer my MySQL database?

To administer/manage your MySQL database we provide the popular program phpMyAdmin. The program...

How do I view my website statistics?

We provide several different statistics programs within cPanel for you to view and analyse your...