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
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...
Do you support TeamSpeak?
We do not support Teamspeak on our servers but allow you to create a subdomain such as...
html or htm parsed as shtml not working
To parse .html or .htm files as .shtml add the following to your .htaccess file in the...
Set CORS header to Allow Access for any Incoming Domain
The following may be used to set to always set the CORS header for any incoming domains without...
Why do I get emails for cron jobs?
This is the default. If you would like to disable receiving emails when a cron job runs append...
