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

Convert PDF to HTML Service

To convert your PDF files to html try using the following converter tool from Adobe:...

Enable Mod Rewrite

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

301 Redirect

This code will redirect all visitors who attempt to access the old-url.html page to the...

What is a virtual Domain?

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

“Not Secure” Web Error

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