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

What are these vt directories?

Those are FrontPage extension directories. If you have and no longer need them you can uninstall...

What is a virtual Domain?

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

Domain Slamming - Beware

There are several companies out there using a predatory practice of attempting to have you renew...

osCommerce password reset

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

Adding HTML to Site Builder

When adding HTML code/source in site builders be sure you are in HTML mode. There is often a...