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

  • 418 Users Found This Useful

Was this answer helpful?

Related Articles

How can I change the index listing in a directory?

You can change the initial page that is sent to client requests when a directory is accessed by...

.htaccess referral redirect

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

I need a module installed but I dont have rights.

No problem. Send us a trouble ticket and we will install the module as long as there are no...

osCommerce password reset

How to reset your osCommerce admin login... You can reset your osCommerce administrative login...

Other websites keep framing my site. How can I prevent?

This issue can be pretty annoying to some. The following javascript is a great tool in preventing...