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

Why can users behind proxies not see my site?

If you have enabled hot link protection users behind proxies may not be able to see your site...

osCommerce password reset

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

Why do I get emails for cron jobs?

This is the default. If you would like to disable receiving emails when a cron job runs append...

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

Inode issues

There are many issues that can arise from reaching your inode limit. The inode limit is the total...