Here is an easy script to help you backup your databases.
Please note that you are responsible for any backups of your data. Use the following to create an automatic backup of your site.
Note that this should be entered on one line as a cron job in your cPanel.
| Code: |
|
date=`date -R`; mysqldump -u"yourdbusername" -p"yourdbpassword" --all-databases > /home/YOURHOME/public_html/backups/xbackup_$date.sql; gzip -f /home/YOURHOME/public_html/backups/xbackup_*.sql |
After this backup is created, you should download it to your hard drive in case it needs to be restored.
