????Shell?????????д?????????????????????Щ???????????????п?????С??????????????????????????С????????????shell?????????????????Щ????д????????????У???????????????????Щ???????
???????????????????????????????????????y?????????????????????shell scripting?? mysqldump??crontab??
???????ò????????κ?Linux??UNIX??

??????????????????mysql???????
??????Shell???????????????????????????????????????????У??????????????????????????????????ɡ?????????????????mysqlump ???????????н??????????????
????1. ???????“backup”??“oldbackup”
????#mkdir /backup
????#mkdir /oldbackup
????2. ??????????????????????????“backup.sh”
??????????????? vi
????# vi /backup/backup.sh
???????????????????????? backup.sh ????У?
????#!bin/bash
????cd /backup
????echo “You are In Backup Directory”
????mv backup* /oldbackup
????echo “Old Databases are Moved to oldbackup folder”
????Now=$(date +”%d-%m-%Y--%H:%M:%S”)
????File=backup-$Now.sql
????mysqldump –u user-name  –p ‘password’ database-name > $File
????echo “Your Database Backup Successfully Completed”
????????????
?????м?????8???????У???mysqldump????????????????????????????????????????
??????иy???????????? /backup ???????y???????е?????????????? /oldbackup ??????У????????????????????????????????????? mysqldump ????????????“.sql”?????????????????
????3. ???? backup.sh ???????????????
????# chmod +x /backup/backup.sh
????4. ??н??
????#./backup.sh
??????????н????????????????
????root@Server1:/download#./backup.sh
????You areinDownload Directory
????Old Backup DatabaseisMoved to oldbackup folder
????database backup successful completed
????root@Server1:/download#
????????????иy?????????“no such file”?????????????????????????????????????????иy???????????????????????????????
????5. ???cron?????????
???????Cron????????иy??????????????ɡ???? crontab ?????cron ??е???????
????#crontab –e
????????????????????????д????漴?ɡ?
????013* * * * /backup/backup.sh
?????????????????????????1??????????????????????С??й?cron??????????????????????crontab???
???????????????????????????????????????????д????????????????????????????????????????????????????????????????????????л????????顣