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

Why is my account suspended?

Why is my account suspended? If you are receiving an account suspended page when trying to access...

How can I turn off directory indexing?

In the directory that you wish you turn off directory indexing, you can do it under Index Manager...

Redirect http to https and www

To forward a website to use both www. and https:// use the following in an .htaccess file:...

Disable error_log via htaccess

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