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

Common Search Engine Optimization Tips

Get other websites to link to you. Have your website linked and posted in socal media...

Error 406 unacceptable

This error can be caused by several factors. One cause can be the incorrect permissions are set...

I have a reseller account. What can I use for billing software and automation?

There are many great programs that work for both billing, domain and cpanel integration. Check...

How do I parse html files as shtml?

Create an .htaccess file in the directory needed and add the following: AddHandler...

Password Protect Directories

Within control panel select Password Protection. Select the directory you would like to protect....