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

Unable to view Ultrawebhosting.com from my foreign browser

We are an American company based out of Seattle, WA. Our website is written in English as a...

Show longer file names in directory/folder index

If you've ever wanted to show longer file names in your directory listing just create or edit an...

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

How do I customize error messages for my site?

Within control panel select Custom Error Pages. Select the error code link and place whatever...

View your website in older browser versions

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