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
Related Articles
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...
htaccess referral redirect
It is often useful to redirect a visitor to a page based on the referring website. There are...
My index page does not load - Why not?
Filenames are case sensitive. Be sure you have an index filename all in lower case. Examples are...
Adding HTML to Site Builder
When adding HTML code/source in site builders be sure you are in HTML mode. There is often a...
Some visitors in China and Russia cannot reach my website
Some networks known for abusive activity such as hacking in countries such as China, North Korea...
