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

htaccess referral redirect

It is often useful to redirect a visitor to a page based on the referring website. There are...

Set CORS header to Allow Access for any Incoming Domain

The following may be used to set to always set the CORS header for any incoming domains without...

Convert PDF to HTML Service

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

How can I tell how much disk space I have available?

To see how much disk space you have available, go to your control panel and on the left side of...

Disable error_log via htaccess

Prevent public display of PHP errors via htaccess# supress php errorsphp_flag...