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
Howto: Add another website to your account
You can add another website to your hosting account if your hosting plan allows for more than one...
Firefox : Secure Connection Failed An error occurred during a connection to SSL received a record that exceeded the maximum permissible error message
Secure Connection Failed An error occurred during a connection to . SSL received a record that...
I have a reseller account. What can I use for billing software and automation?
There are many great programs that work for both billing, domain and cpanel integration. Check...
What are these vt directories?
Those are FrontPage extension directories. If you have and no longer need them you can uninstall...
How do I customize error messages for my site?
Within control panel select Custom Error Pages. Select the error code link and place whatever...
