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

How do I customize error messages for my site?

Within control panel select Custom Error Pages. Select the error code link and place whatever...

How can I change the default page / document?

Create a .htaccess file, include the below information into it and upload it to the public_html...

Common Search Engine Optimization Tips

Get other websites to link to you. Have your website linked and posted in socal media...

Why is the server load status red?

The server load status will be red if the server is under a little more stress than usual. This...

How can I redirect http to https?

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