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

  • 420 Users Found This Useful

Was this answer helpful?

Related Articles

403 Error on POST

This can occur for several reasons: Be sure your file permissions are correct. If the file needs...

Do you have a firewall?

Yes, our servers have firewalls. For security we close off unused ports and update the server...

osCommerce password reset

How to reset your osCommerce admin login... You can reset your osCommerce administrative login...

Default Nameservers

If you have signed up for an Ultra 1x, Ultra Unlimited, or Ultra Unlimited Pro plan the following...

What is the location of curl?

Curl is located @ /usr/bin/curl