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

https:// with Weebly

To enable and force https:// with your Weebly website, be sure to go into your editor area,...

Your connection to this server has been blocked at the firewall

If you receive the message: "Your connection to this server has been blocked at the firewall. If...

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...

How do I customize error messages for my site?

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

Enable Mod Rewrite

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