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
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...
My pages are updating/refreshing slowly
Refresh is immediate on the server. When a file is updated and uploaded it is there. If you are...
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...
403 Error on POST
This can occur for several reasons: Be sure your file permissions are correct. If the file needs...
Can I change my username?
Usernames are setup in the manner for security. Most programs will allow you to save the...
