???????MySQL???????Shell???
???????????? ???????[ 2015/1/13 13:41:33 ] ??????????????? ????? MySQL
????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???
???????????????????????????????????????????д????????????????????????????????????????????????????????????????????????л????????顣
??????
???·???
????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11????????????????????
2021/4/15 14:41:29??????????5???????????
2021/3/25 17:23:31