Automatic database backups

Automatic database backups

You should always keep backups of your databases, but it's a lot of hassle to download one everyday. This guide shows you how to have a backup sent to your inbox everyday courtesy of Skinnybrown.

  1. Download this file to your computer.

  2. Using Winzip extract and open "sqldump" into a text editor such as Wordpad.

  3. Replace ACCOUNTUSERNAME with your Website Control Panel username, DATABASEUSER with your database user and DATABASEPASSWORD with your database password in the appropriate places.

    Example configuration

  4. Save and upload sqldump into your root directory. You'll know when you are in the right directory because the contents includes public_html, mail, public_ftp, tmp and etc.

  5. Change the permissions (CHMOD) of sqldump to 755.

  6. Cron jobs IconLogin to the Website Control Panel, click the Cron jobs icon and select Standard mode.

  7. In the Command to run box enter:

    /home/ACCOUNTUSERNAME/sqldump

  8. Replacing ACCOUNTUSERNAME with your Website Control Panel username.

  9. Enter your email address in the email box.

  10. Then use the selection boxes to set when and how often you would like to be emailed your database backup. Using the example below it will be emailed every day at 4am. When you're happy with the settings, click the Save Crontab button.

Cron Configuration

And you are done! You will now be emailed a backup of your database at the time specified.

Backing up more than one database
If you have more than one database you wish to backup automatically simply configure the script again and save it with a different filename (such as sqldump2). Upload and configure the cron as before, but be sure to change sqldump to sqldump2.

  • 3 Users Found This Useful
Was this answer helpful?

Related Articles

Automatically empty spam folder

We offer you the option of filtering spam email in to a folder called spam, this feature is...

Reduce website loading times

We support HTTP compression, this speeds up the loading time of your website by compressing...

Publicly accessible statistics

It is possible to make your Webalizer usage statistics available to the public with an easy to...