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

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

Point my domain to my wix account

How can I point my domain name to my wix.com account?To set this up you will want to login to...

vBulletin fsockopen() [function.fsockopen]: unable to connect

When setting up mail in vBulletin be sure you are using localhost for the mail server along with...

View your website in older browser versions

As developers and webmasters it is always important to make sure your website works in several...

Enable Mod Rewrite

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