Is it possible to make a cron to backup my database at specific times?

Yes, this can be very useful for forum/message board sites with large databases. In your control panel under cron jobs use the following command:

mysqldump --user=YOURDBUSERNAME --password=YOURDBPASSWORD --quick --add-drop-table --add-locks --extended-insert --lock-tables --all DATABASENAME | gzip > /home/username/path/to/backup/folder/databasename-`date -I`.gz

  • 418 Users Found This Useful

Was this answer helpful?

Related Articles

How to use SharedSSL

SharedSSL is now available with our Ultra Unlimited. It is not as professional looking as having...

What is the location of curl?

Curl is located @ /usr/bin/curl

What perl modules are installed on the server?

You can get a complete list of the modules that are installed by going to the control panel and...

My site was hacked

This typically occurs when you are running a script/app on your website which is out-dated and...

Howto: Add another website to your account

You can add another website to your hosting account if your hosting plan allows for more than one...