Online computer courses, code, programming tutorial and sidebar information for monitoring Canadian S&P/TSX index. Build friendship and networking. Welcome to visit my blogs often!!! I also have two other sites: YouTube Channel and Google site.
Adsense
Popular Posts
- PHPWind-- A PHP forum script applcaition in China
- Using Cron Job to process PHP scripts
- job interview questions (1)
- PHP connect IBM db2 database in XAMPP
- Datatable export excel wraptext and newline
- Install PHPMailer 5.2.4 and use smtp gmail
- Free host forum is not reliable
- Set up a child account and set screen time limit in Windows 8
- PHP - Export Content to MS Word document
- Powerful js library datable to export table in pdf, excel, sorting, freezing column and table header fixed (sticky)
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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment