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
Setting up Zend Framework
When setting up Zend Frameworks in your hosting account be sure to upload your frameworks folder...
How do I submit my site to search engines?
Submit your website to popular search engines to increase your webite's exposure and visitor...
Error 508 / 503 - Resource Limit Reached
To help maintain the stability of servers and keep websites fast, UltraWebHosting has resource...
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...
I need a module installed but I do not have rights
No problem. Send us a trouble ticket and we will install the module as long as there are no...