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

Creating a Form Button

Sometimes all you need is a simple button. The following pages are pretty useful tools for...

Whitelisting Our Support System Email Address

Whitelist Instructions Because we use often use html emails with http addresses in them, our...

Error 508 / 503 - Resource Limit Reached

To help maintain the stability of servers and keep websites fast, UltraWebHosting has resource...

“Not Secure” Web Error

In this day and age browsers now default to using https:// instead of http://. We make SSL...

403 Error on POST

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