Monday, April 6, 2015

Daily backup MySQL database to another computer



Assume MySQL server is example.ca, I want to dump MySQL database test to dev2.ca daily.
 1) In PHPMyAdmin, click Users, add new user jiansenbk and  host dev2.ca and  database test
grant all
2) In dev2.ca
create MySQLdump1.sh (no line break below)
mysqldump  -h example.ca -u jiansenbk -pPass2 test
| gzip >/home/jiansen/mysqldump/MySQLDB_`date +"%Y%m%d"`.sql.gz

3) chmod +x MySQLdump1.sh

4) crontab -e
and enter (no linebreak, chnage server and user name password and database to yours)
45 23 * * * /home/jiansen/mysqldump/MySQLdump1.sh 2>&1>>/home/jiansen/mysqldump/mysqlbackup.log


Every night 11:45. MySQL database test is dump to /home/jiansen/mysqldump with different timestamps
Video: Daily backup MySQL database to another computer

No comments:

Post a Comment