cPanel Backups

Note: The best method of backing up data is one that is daily, and save the data to a different location. If you backup your information to the server your websites are on, a crash will eliminate both sets of data.

Simple Backups

Automatic MySQL Backups


Navigate to "Cron Jobs" and choose the "Advanced (Unix Style)" layout.

You will be given the following options:

Minute: 0
Hour: 3 This represents 3AM, which is usually an inactive time
Day: * 
Means the script is run every day of the week
Month: * Means the script is run every month of the year
Weekday: 0 
Means the script is run every sunday
Command: mysqldump --opt -Q -u dbusername --password=dbpassword dbname > ~/pathto/backups/sunday.sql

In the command prompt, you will need to replace the red variables that correspond to your information. Remember, if you are on shared hosting, your dbname and dbusername probably have a prefix.

Also note that it is asking for the backup path, not the backup URL.

After doing the first script repeat it six times but change the weekday from 0 to 1 (then 1 to 2, until you reach 6) and the filename from sunday to monday (then monday to tuesday, until you reach saturday).

With this method, you are backing up everyday, BUT you have copies from the past seven days instead of rewriting the same copy everyday. This is advantageous because you may want to restore to a certain point or your only backup may have been corrupted.

  • 120 Users Found This Useful
Was this answer helpful?

Related Articles

Is ImageMagick installed?

Yes, we have ImageMagick installed and updated on all servers. The path to it is: /usr/bin/

How do I access my control panel?

Shared accounts can go to https://YourSitesIPAddress:2083 or https://YourDomain:2083...

Is anonymous FTP enabled on your servers?

For security reasons, anonymous FTP is not enabled on shared or reseller servers. It may be...

Is there a shared SSL certificate I can use?

No. You'll need to purchase your own SSL certificate if you need to set up SSL access....

How do I add an Email address?

To add a new email address:Type the email address to be created in the Email field.If...