How to Create Back Up Copy of Your Site Regularly
In this article, I would tell you in short how to regularly create a back up copy of the whole site.
Solution:
You can create back up copy of the database only or back up copy of database and files.
Database backup copy
mysqldump –quick -uUSER -hHOST -p’PASSWORD’ DATABASE | gzip -c > /FULL PATH TO FILE /SITENAME_sql.gz >/dev/null 2>&1
Files backup copy
tar -czvf /FULL PATH TO FILE/SITENAME_files.tar.gz /FULL PATH TO WEB SERVER ROOT/public_html/* >/dev/null 2>&1
Cancel output of information about execution and sending email
If you add ">/dev/null 2>&1" to the end of the command, you will cancel output of information in the time of execution and sending email with a completion report to the main domain address.