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

Why is my account suspended?

Why is my account suspended? If you are receiving an account suspended page when trying to access...

How can I redirect http to https?

Create an .htaccess file with the following contents and upload it to your public_html directory....

Can I change my username?

Usernames are setup in the manner for security. Most programs will allow you to save the...

What is a virtual Domain?

A virtual domain is the base URL of the domain name. Examples include yourdomain.com, and...