{"id":81,"date":"2008-05-18T20:51:00","date_gmt":"2008-05-18T11:51:00","guid":{"rendered":"http:\/\/yokensaka.com\/fedora\/?p=81"},"modified":"2008-05-18T20:51:00","modified_gmt":"2008-05-18T11:51:00","slug":"%e3%83%90%e3%83%83%e3%82%af%e3%82%a2%e3%83%83%e3%83%97%ef%bc%88%e3%82%b5%e3%83%bc%e3%83%90%e3%83%bc%e5%86%85%e3%81%b8%ef%bc%89","status":"publish","type":"post","link":"http:\/\/yokensaka.com\/fedora\/?p=81","title":{"rendered":"\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\uff08\u30b5\u30fc\u30d0\u30fc\u5185\u3078\uff09"},"content":{"rendered":"

\u25a0\u3000FC2\uff5eFC6 \/ Fedora7 \/ Fedora8 \/ Fedora9<\/b>
\n\u30b5\u30fc\u30d0\u30fc\u306e\u30c7\u30fc\u30bf\u3092 tar \u30b3\u30de\u30f3\u30c9\u3092\u4f7f\u3044\u3001\u540c\u3058\u30b5\u30fc\u30d0\u30fc\u5185\u306b\u5727\u7e2e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u304c\u51fa\u6765\u308b\u3088\u3046\u306b\u3059\u308b\u3002
\n\u25a0 \u30b5\u30fc\u30d0\u30fc\u5074\u3067\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u8a2d\u5b9a<\/b>
\n1.\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u30b9\u30af\u30ea\u30d7\u30c8\u4f5c\u6210<\/b><\/p>\n

[root@server ~]# vi backup.sh\n#!\/bin\/bash\nLANG=C\n# \u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u5bfe\u8c61\u30d5\u30a1\u30a4\u30eb\u30ea\u30b9\u30c8\u540d\nBACKUPLIST=\/root\/backuplist\n[ ! -s $BACKUPLIST ] && echo \"$BACKUPLIST is not found\" && exit 1\n# \u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u5bfe\u8c61\u5916\u30d5\u30a1\u30a4\u30eb\u30ea\u30b9\u30c8\u540d\nBACKUPNOLIST=\/root\/backupnolist\n# \u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u5148\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u540d\nBACKUPDIR=\/backup\nmkdir -p $BACKUPDIR\n# \u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u306e\u4fdd\u5b58\u4e16\u4ee3\u6570\nBACKUPGEN=12\n# \u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u306e\u30ed\u30b0\u30d5\u30a1\u30a4\u30eb\u540d\nBACKUPLOG=\/var\/log\/backup.log\n# \u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u5148\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u3092\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u5bfe\u8c61\u5916\u30d5\u30a1\u30a4\u30eb\u30ea\u30b9\u30c8\u306b\u8ffd\u52a0\nTMPBACKUPNOLIST=`mktemp`\n[ -s $BACKUPNOLIST ] && cat $BACKUPNOLIST > $TMPBACKUPNOLIST\necho $BACKUPDIR >> $TMPBACKUPNOLIST\n# \u524d\u56de\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3057\u305f\u30d5\u30a1\u30a4\u30eb\u540d\u5909\u66f4\ncd $BACKUPDIR\nOLDBACKUPFILE=`ls backup.tar.bz2* 2>\/dev\/null`\nif [ -f $OLDBACKUPFILE ]; then\nTIMESTAMP=`ls --full-time $OLDBACKUPFILE|awk '{print $6}'|tr -d -`\nmv $BACKUPDIR\/$OLDBACKUPFILE $BACKUPDIR\/${TIMESTAMP}$OLDBACKUPFILE > \/dev\/null 2>&1\nfi\n# \u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u306e\u30ed\u30b0\u30d5\u30a1\u30a4\u30eb\u4f5c\u6210\nrm -f $BACKUPLOG\ntouch $BACKUPLOG\nchmod 400 $BACKUPLOG\n# \u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u306e\u5b9f\u884c\necho \"`date` backup start\" >> $BACKUPLOG\ntar cjvfP $BACKUPDIR\/backup.tar.bz2 -T $BACKUPLIST -X $TMPBACKUPNOLIST >> $BACKUPLOG 2>&1\n[ $? -ne 0 ] && cat $BACKUPLOG | mail -s \"BACKUP NG\" root && exit 1\necho \"`date` backup end\" >> $BACKUPLOG\n# \u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u306e\u4fdd\u5b58\u4e16\u4ee3\u3092\u8d85\u3048\u305f\u53e4\u3044\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u30d5\u30a1\u30a4\u30eb\u3092\u524a\u9664\nif [ $(ls \/backup\/|wc -l) -gt $BACKUPGEN ]; then\nOLDBACKUPCNT=`expr $(ls \/backup\/|wc -l) - $BACKUPGEN`\nfor file in `ls -t $BACKUPDIR|tail -n $OLDBACKUPCNT`\ndo\nrm -f $BACKUPDIR\/$file\ndone\nfi\n# \u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u5bfe\u8c61\u5916\u30d5\u30a1\u30a4\u30eb\u3092\u524a\u9664\nrm -f $TMPBACKUPNOLIST<\/pre>\n
\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u30b9\u30af\u30ea\u30d7\u30c8\u3078\u5b9f\u884c\u6a29\u9650\u4ed8\u52a0<\/p>\n
[root@server ~]# chmod 700 backup.sh<\/pre>\n
2.\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u5bfe\u8c61\u30d5\u30a1\u30a4\u30eb\u30ea\u30b9\u30c8\u306e\u4f5c\u6210<\/b>
\n\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u5bfe\u8c61\u30d5\u30a1\u30a4\u30eb\u30ea\u30b9\u30c8\u306b\/var\/www\/html\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u3092\u8ffd\u52a0<\/p>\n
[root@server ~]# echo \"\/var\/www\/html\" >> backuplist<\/pre>\n
3.\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u5bfe\u8c61\u5916\u30d5\u30a1\u30a4\u30eb\u30ea\u30b9\u30c8\u306e\u4f5c\u6210<\/b>
\n\u4f8b\u3068\u3057\u3066\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u5bfe\u8c61\u5916\u30d5\u30a1\u30a4\u30eb\u30ea\u30b9\u30c8\u306b\/var\/www\/error\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u3092\u8ffd\u52a0<\/p>\n
[root@server ~]# echo \"\/var\/www\/error\" >> backupnolist<\/pre>\n
4.\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u30b9\u30af\u30ea\u30d7\u30c8\u306e\u78ba\u8a8d<\/b><\/p>\n
[root@server ~]# .\/backup.sh\u3000\u2190\u3000\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u30b9\u30af\u30ea\u30d7\u30c8\u306e\u5b9f\u884c\n[root@server ~]# ls -lh \/backup\u3000\u2190\u3000\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u5148\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306e\u7167\u4f1a\n\u5408\u8a08 754M\n-rw-r--r-- 1 root root 753M 10\u6708 27 20:15 backup.tar.bz2\n\u2191 backup.tar.bz2\u3068\u3044\u3046\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u30d5\u30a1\u30a4\u30eb\u304c\u51fa\u6765\u3066\u3044\u308b<\/pre>\n
5.\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u3001\u30d5\u30a1\u30a4\u30eb\u306e\u78ba\u8a8d<\/b><\/p>\n
[root@server ~]# tar tjvf \/backup\/backup.tar.bz2\n\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3057\u305f\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u3001\u30d5\u30a1\u30a4\u30eb\u304c\u4e00\u89a7\u8868\u793a\u3055\u308c\u308b<\/pre>\n
6.\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u5b9a\u671f\u81ea\u52d5\u5b9f\u884c\u8a2d\u5b9a <\/b><\/p>\n
[root@server ~]# crontab -e\n00 05 * * * \/root\/backup.sh\u3000\u2190\u3000\u8ffd\u52a0(\u6bce\u65e505:00\u306b\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3092\u5b9f\u884c\u3059\u308b)<\/pre>\n
\u25a0MySQL\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7<\/b>
\nMySQL\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u306b\u3082\u8272\u3005\u306a\u65b9\u6cd5\u304c\u3042\u308b\u304c\u3001\u3082\u3063\u3068\u3082\u7c21\u5358\u306a\u65b9\u6cd5\u306fmysqldump\u3092\u5229\u7528\u3057\u3066\u81ea\u30b5\u30fc\u30d0\u30fc\u5185\u306e\/backup\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u30fc\u306b\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3059\u308b\u3053\u3068\u3060\u3068\u601d\u3046\u3002
\n1.mysqldump\u306b\u3088\u308b\u30d0\u30c3\u30af\u30a2\u30c3\u30d7<\/b>
\n\u305f\u3068\u3048\u3070\u3001\u5168\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\/backup\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u30fc\u306balldump.sql\u3068\u3044\u3046\u540d\u524d\u3067\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3059\u308b\u306e\u306a\u3089\u6b21\u306e\u3088\u3046\u306b\u3059\u308b\u3002linux\u3067\u306f\u3053\u308c\u3092cron\u304b\u3089\u8d77\u52d5\u3055\u305b\u308c\u3070\u6df1\u591c\u306b\u7121\u4eba\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3055\u305b\u308b\u3053\u3068\u304c\u51fa\u6765\u308b\u3002<\/p>\n
[root@server ~]# mysqldump -A -uroot -p\u30d1\u30b9\u30ef\u30fc\u30c9 -Q --opt -r\/backup\/alldump.sql<\/pre>\n
\u500b\u5225\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\/backup\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u30fc\u306b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d.sql\u3068\u3044\u3046\u540d\u524d\u3067\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3057\u305f\u3044\u5834\u5408\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u3059\u308b\u3002<\/p>\n
[root@server ~]# mysqldump mysql -uroot -p\u30d1\u30b9\u30ef\u30fc\u30c9 -Q --opt -r\/backup\/mysqldump.sql\n[root@server ~]# mysqldump fc -uroot -p\u30d1\u30b9\u30ef\u30fc\u30c9 -Q --opt -r\/backup\/fcdump.sql\n[root@server ~]# mysqldump ss1129 -uroot -p\u30d1\u30b9\u30ef\u30fc\u30c9 -Q --opt -r\/backup\/ss1129dump.sql\n[root@server ~]# mysqldump nucleus -uroot -p\u30d1\u30b9\u30ef\u30fc\u30c9 -Q --opt -r\/backup\/nucleusdump.sql\n[root@server ~]# mysqldump taka -uroot -p\u30d1\u30b9\u30ef\u30fc\u30c9 -Q --opt -r\/backup\/takadump.sql<\/pre>\n
2.MySQL\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u81ea\u52d5\u30d0\u30c3\u30af\u30a2\u30c3\u30d7<\/b><\/p>\n
MySQL\u306e\u500b\u5225\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\/backup\u306b\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3059\u308b\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u4f5c\u6210\u3002\n[root@server ~]# vi mysqldump.sh\n#! \/bin\/sh\nmysqldump mysql -uroot -p\u30d1\u30b9\u30ef\u30fc\u30c9 -Q --opt -r\/backup\/mysqldump.sql\nmysqldump fc -uroot -p\u30d1\u30b9\u30ef\u30fc\u30c9 -Q --opt -r\/backup\/fcdump.sql\nmysqldump ss1129 -uroot -p\u30d1\u30b9\u30ef\u30fc\u30c9 -Q --opt -r\/backup\/ss1129dump.sql\nmysqldump nucleus -uroot -p\u30d1\u30b9\u30ef\u30fc\u30c9 -Q --opt -r\/backup\/nucleusdump.sql\nmysqldump taka -uroot -p\u30d1\u30b9\u30ef\u30fc\u30c9 -Q --opt -r\/backup\/takadump.sql\n\u5b9f\u884c\u6a29\u9650\u3092\u4e0e\u3048\u308b\n[root@server ~]# chmod 700 mysqldump.sh\n\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u5b9f\u884c\n[root@server ~]# .\/mysqldump.sh\n\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3055\u308c\u3066\u308b\u304b\u78ba\u8a8d\n[root@linux ~]# ls -lh \/backup\n\u5408\u8a08 1.2G\n-rw-r--r-- 1 root root 753M 10\u6708 28 05:16 backup.tar.bz2\n-rw-r--r-- 1 root root 377K 10\u6708 28 05:00 fcdump.sql\n-rw-r--r-- 1 root root 150K 10\u6708 28 05:00 ss1129dump.sql\n-rw-r--r-- 1 root root 285K 10\u6708 28 05:00 mysqldump.sql\n-rw-r--r-- 1 root root  12M 10\u6708 28 05:00 nucleusdump.sql\n-rw-r--r-- 1 root root 234K 10\u6708 28 05:00 takadump.sql<\/pre>\n
3.\u81ea\u52d5\u5b9f\u884c<\/b>
\n\u3059\u3067\u306b\u6bce\u65e55:00\u306b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u4ee5\u5916\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3092\u81ea\u52d5\u5b9f\u884c\u3055\u305b\u3066\u3044\u308b\u306e\u3067\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3082\u9023\u643a\u3057\u3066\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3059\u308b\u3002
\n\u5148\u306b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3057\u3066\u6b21\u306b\u4ed6\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3092\u5b9f\u884c\u3059\u308b\u3088\u3046\u306b\/root\/backup.sh\u306e\u524d\u306b\/root\/mysqldump.sh\u3092\u5165\u308c\u308b\u3002<\/p>\n
[root@server ~]# crontab -e\n00 05 * * * \/root\/mysqldump.sh ; \/root\/backup.sh<\/pre>\n
4.\u5fa9\u5143<\/b>
\n\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u30d5\u30a1\u30a4\u30eb\u3092\u30b5\u30fc\u30d0\u30fc\u3078\u5fa9\u5143\u3059\u308b\u5fc5\u8981\u304c\u51fa\u3066\u304d\u305f\u5834\u5408\u306f\u3001\u4ee5\u4e0b\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3059\u308b\u3053\u3068\u3067\u3001\u30d1\u30fc\u30df\u30c3\u30b7\u30e7\u30f3\u3001\u6240\u6709\u8005\u3082\u542b\u3081\u3066\u5143\u306e\u30e1\u30a4\u30f3\u30b5\u30fc\u30d0\u30fc\u306b\u30ea\u30b9\u30c8\u30a2\u51fa\u6765\u308b\u3002<\/p>\n
[root@server ~]# tar jxvfP \/backup\/backup.tar.bz2\n\u500b\u5225\u306b\u30d1\u30fc\u30df\u30c3\u30b7\u30e7\u30f3\u3001\u6240\u6709\u8005\u3082\u542b\u3081\u3066\u5fa9\u5143\u3059\u308b\u5834\u5408\u306f\n[root@server ~]# tar jxvfP \/backup\/backup.tar.bz2 \/var\/www\/html\/\u30d5\u30a1\u30a4\u30eb\u540d<\/pre>\n
mysqldump\u3067\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3057\u305f\u30d5\u30a1\u30a4\u30eb\u3092\u30ea\u30b9\u30c8\u30a2\u3059\u308b\u306b\u306fmysql\u30b3\u30de\u30f3\u30c9\u3092\u4f7f\u3046\u3002<\/p>\n
\u5168\u3066\u3092\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3057\u305f\u5834\u5408\u306e\u30ea\u30b9\u30c8\u30a2\n[root@server ~]# mysql -uroot -p\u30d1\u30b9\u30ef\u30fc\u30c9 < \/backup\/alldump.sql\n\u500b\u5225\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3057\u305f\u5834\u5408\u306e\u30ea\u30b9\u30c8\u30a2\n[root@server ~]# mysql -uroot -p\u30d1\u30b9\u30ef\u30fc\u30c9 mysql < \/backup\/mysqldump.sql\n[root@server ~]# mysql -uroot -p\u30d1\u30b9\u30ef\u30fc\u30c9 fc < \/backup\/fcdump.sql\n[root@server ~]# mysql -uroot -p\u30d1\u30b9\u30ef\u30fc\u30c9 ss1129 < \/backup\/ss1129dump.sql\n[root@server ~]# mysql -uroot -p\u30d1\u30b9\u30ef\u30fc\u30c9 nucleus < \/backup\/nucleusdump.sql\n[root@server ~]# mysql -uroot -p\u30d1\u30b9\u30ef\u30fc\u30c9 taka < \/backup\/takadump.sql\nmysql\u3092\u30ea\u30b9\u30c8\u30a2\u3057\u305f\u5834\u5408\u3084\u5168\u3066\u3092\u30ea\u30b9\u30c8\u30a2\u3057\u305f\u5834\u5408\u306fmysql\u3092\u518d\u8d77\u52d5\u304c\u5fc5\u8981\n[root@server ~]# \/etc\/init.d\/mysql restart<\/pre>\n
\u25b2 \u30da\u30fc\u30b8\u30c8\u30c3\u30d7\u3078<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"
\u25a0\u3000FC2\uff5eFC6 \/ Fedora7 \/ Fedora8 \/ Fedora9 \u30b5\u30fc\u30d0\u30fc\u306e\u30c7\u30fc\u30bf\u3092 tar \u30b3\u30de\u30f3\u30c9\u3092\u4f7f\u3044\u3001\u540c\u3058\u30b5\u30fc\u30d0\u30fc\u5185\u306b\u5727\u7e2e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u304c\u51fa\u6765\u308b\u3088\u3046\u306b\u3059\u308b\u3002 \u25a0 \u30b5\u30fc\u30d0\u30fc\u5074\u3067\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u8a2d\u5b9a 1.\u30d0 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[30],"tags":[],"class_list":["post-81","post","type-post","status-publish","format-standard","hentry","category-26-"],"_links":{"self":[{"href":"http:\/\/yokensaka.com\/fedora\/index.php?rest_route=\/wp\/v2\/posts\/81","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/yokensaka.com\/fedora\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/yokensaka.com\/fedora\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/yokensaka.com\/fedora\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/yokensaka.com\/fedora\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=81"}],"version-history":[{"count":0,"href":"http:\/\/yokensaka.com\/fedora\/index.php?rest_route=\/wp\/v2\/posts\/81\/revisions"}],"wp:attachment":[{"href":"http:\/\/yokensaka.com\/fedora\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=81"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/yokensaka.com\/fedora\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=81"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/yokensaka.com\/fedora\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=81"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}