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

View your website in older browser versions.

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

Prevent CloudFlare from Loading a .js or Script

Sometimes CloudFlare / Rocket Loader can have problems with a script and hose it up. To have...

Heartbleed Vulnerablity, Risk and Fix

The Heartbleed bug (http://en.wikipedia.org/wiki/Heartbleed_bug) is a serious vulnerability which...

Sub-Domain times out

When you add a sub-domain and it times out make sure you do not have redirection set from that...

I can not move out of the / directory. Why not?

For security reasons, you cannot move out of the root folder of your own domain.