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...
Setting up Zend Framework
When setting up Zend Frameworks in your hosting account be sure to upload your frameworks folder...
Creating and Submitting a Google Sitemap
Creating a Google sitemap can be easy and beneficial. By using one, you are pushing a full list...
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...
When I upload an htaccess file it disappears
On unix/linux systems, files that start with a . are considered hidden so many ftp programs do...
