Cheap Website Hosting in Australia

Support Knowledge Base

You can contact us for support using our contact form, email or phone.
You will also find a lot answers to your questions in our Knowledge Base.

Search Knowledge Base

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 under Download 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

cPanel