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 make search engine friendly urls with my app?

The best source is the support forums for the particular app. You can also check the following...

My site was hacked

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

I need a module installed but I do not have rights

No problem. Send us a trouble ticket and we will install the module as long as there are no...

Why is the server load status red?

The server load status will be red if the server is under a little more stress than usual. This...

View your website in older browser versions

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