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

What are these vt directories?

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

How can I redirect http to https?

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

osCommerce password reset

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

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

My site was hacked

This typically occurs when you are running a script/app on your website which is out-dated and...