{"id":65,"date":"2014-12-21T08:52:00","date_gmt":"2014-12-20T23:52:00","guid":{"rendered":"http:\/\/yokensaka.com\/centos\/?p=65"},"modified":"2018-10-04T02:17:11","modified_gmt":"2018-10-03T17:17:11","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\/centos\/?p=65","title":{"rendered":"CentOS 7 \u30d0\u30c3\u30af\u30a2\u30c3\u30d7\uff08\u30b5\u30fc\u30d0\u5185\u3078\uff09"},"content":{"rendered":"<p>\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<br \/>\n<b>\u25a0 \u30b5\u30fc\u30d0\u30fc\u5074\u3067\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u8a2d\u5b9a<\/b><\/p>\n<p><b>1.\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u30b9\u30af\u30ea\u30d7\u30c8\u4f5c\u6210<\/b><\/p>\n<pre>[root@server1 ~]# vi backup.sh\r\n#!\/bin\/bash\r\nLANG=C\r\n# \u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u5bfe\u8c61\u30d5\u30a1\u30a4\u30eb\u30ea\u30b9\u30c8\u540d\r\nBACKUPLIST=\/root\/backuplist\r\n[ ! -s $BACKUPLIST ] &amp;&amp; echo \"$BACKUPLIST is not found\" &amp;&amp; exit 1\r\n# \u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u5bfe\u8c61\u5916\u30d5\u30a1\u30a4\u30eb\u30ea\u30b9\u30c8\u540d\r\nBACKUPNOLIST=\/root\/backupnolist\r\n# \u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u5148\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u540d\r\nBACKUPDIR=\/backup\r\nmkdir -p $BACKUPDIR\r\n# \u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u306e\u4fdd\u5b58\u4e16\u4ee3\u6570\r\nBACKUPGEN=10\r\n# \u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u306e\u30ed\u30b0\u30d5\u30a1\u30a4\u30eb\u540d\r\nBACKUPLOG=\/var\/log\/backup.log\r\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\r\nTMPBACKUPNOLIST=`mktemp`\r\n[ -s $BACKUPNOLIST ] &amp;&amp; cat $BACKUPNOLIST &gt; $TMPBACKUPNOLIST\r\necho $BACKUPDIR &gt;&gt; $TMPBACKUPNOLIST\r\n# \u524d\u56de\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3057\u305f\u30d5\u30a1\u30a4\u30eb\u540d\u5909\u66f4\r\ncd $BACKUPDIR\r\nOLDBACKUPFILE=`ls backup.tar.bz2* 2&gt;\/dev\/null`\r\nif [ -f $OLDBACKUPFILE ]; then\r\nTIMESTAMP=`ls --full-time $OLDBACKUPFILE|awk '{print $6}'|tr -d -`\r\nmv $BACKUPDIR\/$OLDBACKUPFILE $BACKUPDIR\/${TIMESTAMP}$OLDBACKUPFILE &gt; \/dev\/null 2&gt;&amp;1\r\nfi\r\n# \u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u306e\u30ed\u30b0\u30d5\u30a1\u30a4\u30eb\u4f5c\u6210\r\nrm -f $BACKUPLOG\r\ntouch $BACKUPLOG\r\nchmod 400 $BACKUPLOG\r\n# \u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u306e\u5b9f\u884c\r\necho \"`date` backup start\" &gt;&gt; $BACKUPLOG\r\ntar cjvfP $BACKUPDIR\/backup.tar.bz2 -T $BACKUPLIST -X $TMPBACKUPNOLIST &gt;&gt; $BACKUPLOG 2&gt;&amp;1\r\n[ $? -ne 0 ] &amp;&amp; cat $BACKUPLOG | mail -s \"BACKUP NG\" root &amp;&amp; exit 1\r\necho \"`date` backup end\" &gt;&gt; $BACKUPLOG\r\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\r\nif [ $(ls \/backup\/|wc -l) -gt $BACKUPGEN ]; then\r\nOLDBACKUPCNT=`expr $(ls \/backup\/|wc -l) - $BACKUPGEN`\r\nfor file in `ls -t $BACKUPDIR|tail -n $OLDBACKUPCNT`\r\ndo\r\nrm -f $BACKUPDIR\/$file\r\ndone\r\nfi\r\n# \u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u5bfe\u8c61\u5916\u30d5\u30a1\u30a4\u30eb\u3092\u524a\u9664\r\nrm -f $TMPBACKUPNOLIST\r\n<\/pre>\n<p>\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u30b9\u30af\u30ea\u30d7\u30c8\u3078\u5b9f\u884c\u6a29\u9650\u4ed8\u52a0<\/p>\n<pre>[root@server1 ~]# chmod 700 backup.sh<\/pre>\n<p><b>2.\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u5bfe\u8c61\u30d5\u30a1\u30a4\u30eb\u30ea\u30b9\u30c8\u306e\u4f5c\u6210<\/b><br \/>\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<pre>[root@server1 ~]# echo \"\/var\/www\/html\" &gt;&gt; backuplist<\/pre>\n<p><b>3.\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u5bfe\u8c61\u5916\u30d5\u30a1\u30a4\u30eb\u30ea\u30b9\u30c8\u306e\u4f5c\u6210<\/b><br \/>\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<pre>[root@server1 ~]# echo \"\/var\/www\/error\" &gt;&gt; backupnolist<\/pre>\n<p><b>4.\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u30b9\u30af\u30ea\u30d7\u30c8\u306e\u78ba\u8a8d<\/b><\/p>\n<pre>[root@server1 ~]# .\/backup.sh\u3000\u2190\u3000\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u30b9\u30af\u30ea\u30d7\u30c8\u306e\u5b9f\u884c\r\n[root@server1 ~]# ls -lh \/backup\u3000\u2190\u3000\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u5148\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306e\u7167\u4f1a\r\n\u5408\u8a08 3.3G\r\n-rw-r--r-- 1 root root 3.3G 12\u6708 17 03:05 backup.tar.bz2\r\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<p><b>5.\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u3001\u30d5\u30a1\u30a4\u30eb\u306e\u78ba\u8a8d<\/b><\/p>\n<pre>[root@server1 ~]# tar tjvf \/backup\/backup.tar.bz2\r\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<p><b>6.\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u5b9a\u671f\u81ea\u52d5\u5b9f\u884c\u8a2d\u5b9a <\/b><\/p>\n<pre>\u6bce\u65e52:30\u306b\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3092\u5b9f\u884c\u3059\u308b\r\n[root@server1 ~]# echo \"30 2 * * * root \/root\/backup.sh\" &gt; \/etc\/cron.d\/backup<\/pre>\n<p><b>\u25a0MySQL\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7<\/b><br \/>\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<\/p>\n<p><b>1.mysqldump\u306b\u3088\u308b\u30d0\u30c3\u30af\u30a2\u30c3\u30d7<\/b><br \/>\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<pre># mysqldump -A -uroot -p\u30d1\u30b9\u30ef\u30fc\u30c9 --default-character-set=binary &gt; \/backup\/alldump.sql\r\n<\/pre>\n<p>\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<pre># mysqldump mysql -uroot -p\u30d1\u30b9\u30ef\u30fc\u30c9 --default-character-set=binary &gt; \/backup\/mysqldump.sql\r\n# mysqldump fedora -uroot -p\u30d1\u30b9\u30ef\u30fc\u30c9 --default-character-set=binary &gt; \/backup\/fedoradump.sql\r\n# mysqldump nucleus -uroot -p\u30d1\u30b9\u30ef\u30fc\u30c9 --default-character-set=binary &gt; \/backup\/nucleusdump.sql\r\n# mysqldump taka -uroot -p\u30d1\u30b9\u30ef\u30fc\u30c9 --default-character-set=binary &gt; \/backup\/takadump.sql\r\n# mysqldump centos -uroot -p\u30d1\u30b9\u30ef\u30fc\u30c9 --default-character-set=binary &gt; \/backup\/centosdump.sql<\/pre>\n<p><b>2.MySQL\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u81ea\u52d5\u30d0\u30c3\u30af\u30a2\u30c3\u30d7<\/b><\/p>\n<pre>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\r\n[root@server1 ~]# vi mysqldump.sh\r\n#! \/bin\/sh\r\nmysqldump mysql -uroot -p\u30d1\u30b9\u30ef\u30fc\u30c9 --default-character-set=binary &gt; \/backup\/mysqldump.sql\r\nmysqldump fedora -uroot -p\u30d1\u30b9\u30ef\u30fc\u30c9 --default-character-set=binary &gt; \/backup\/fedoradump.sql\r\nmysqldump nucleus -uroot -p\u30d1\u30b9\u30ef\u30fc\u30c9 --default-character-set=binary &gt; \/backup\/nucleusdump.sql\r\nmysqldump taka -uroot -p\u30d1\u30b9\u30ef\u30fc\u30c9 --default-character-set=binary &gt; \/backup\/takadump.sql\r\nmysqldump centos -uroot -p\u30d1\u30b9\u30ef\u30fc\u30c9 --default-character-set=binary &gt; \/backup\/centosdump.sql\r\n\u5b9f\u884c\u6a29\u9650\u3092\u4e0e\u3048\u308b\r\n[root@server1 ~]# chmod 700 mysqldump.sh\r\n\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u5b9f\u884c\r\n[root@server1 ~]# .\/mysqldump.sh\r\n\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3055\u308c\u3066\u308b\u304b\u78ba\u8a8d\r\n[root@server1 ~]# ls -lh \/backup\r\n\u5408\u8a08 3.4G\r\n-rw-r--r-- 1 root root 3.3G 12\u6708 17 03:05 backup.tar.bz2\r\n-rw-r--r-- 1 root root  13M 12\u6708 17 18:58 blogdump.sql\r\n-rw-r--r-- 1 root root 2.3M 12\u6708 17 18:58 centosdump.sql\r\n-rw-r--r-- 1 root root 694K 12\u6708 17 18:58 fedoradump.sql\r\n-rw-r--r-- 1 root root 503K 12\u6708 17 18:58 mysqldump.sql\r\n-rw-r--r-- 1 root root 788K 12\u6708 17 18:58 takadump.sql<\/pre>\n<p><b>3.\u81ea\u52d5\u5b9f\u884c<\/b><br \/>\n\u3059\u3067\u306b\u6bce\u65e52:30\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\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u306f\u305d\u306e\u524d\u306e\u6bce\u65e52\uff1a00\u306b\u81ea\u52d5\u5b9f\u884c\u3055\u305b\u308b\u3002<\/p>\n<pre>[root@server1 ~]# echo \"0 2 * * * root \/root\/mysqldump.sh\" &gt; \/etc\/cron.d\/mysqldump<\/pre>\n<p>\u3061\u306a\u307f\u306b\u30e1\u30a4\u30f3\u30b5\u30fc\u30d0\u306e\u81ea\u52d5\u5b9f\u884c\u8a2d\u5b9a\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u306a\u3063\u3066\u3044\u308b\u3002<br \/>\n\/etc\/cron.d\u306b\u306f\u6642\u9593\u6307\u5b9a\u306e\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u5165\u308c\u3066\u304a\u304d\u3001\u7279\u306b\u6642\u9593\u6307\u5b9a\u3057\u306a\u304f\u3066\u3082\u826f\u3055\u305d\u3046\u306a\u3082\u306e\u306f\/etc\/cron.daily\u306b\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u5165\u308c\u3066\u304a\u304f\u3002<\/p>\n<pre>[root@server1 ~]# echo \"*\/1 * * * * root \/usr\/ddns\/ddo.jpIP_upgrade.pl\" &gt; \/etc\/cron.d\/ddns\r\n[root@server1 ~]# echo \"0 2 * * * root \/root\/mysqldump.sh\" &gt; \/etc\/cron.d\/mysqldump\r\n[root@server1 ~]# echo \"15 2 * * * root \/root\/mysqlbackup.sh\" &gt; \/etc\/cron.d\/mysqlbackup\r\n[root@server1 ~]# echo \"30 2 * * * root \/root\/backup.sh\" &gt; \/etc\/cron.d\/backup\r\n[root@server1 ~]# mv chkrootkit \/etc\/cron.daily\/\r\n[root@server1 ~]# mv clamscan \/etc\/cron.daily\/<\/pre>\n<p><b>4.\u5fa9\u5143<\/b><br \/>\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<pre>[root@server1 ~]# tar jxvfP \/backup\/backup.tar.bz2\r\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\r\n[root@server1 ~]# tar jxvfP \/backup\/backup.tar.bz2 \/var\/www\/html\/\u30d5\u30a1\u30a4\u30eb\u540d\r\n<\/pre>\n<p>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<pre>\u5168\u3066\u3092\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3057\u305f\u5834\u5408\u306e\u30ea\u30b9\u30c8\u30a2\r\n# mysql -uroot -p\u30d1\u30b9\u30ef\u30fc\u30c9 --default-character-set=binary &lt; \/backup\/alldump.sql\r\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\r\n# mysql -uroot -p\u30d1\u30b9\u30ef\u30fc\u30c9 mysql --default-character-set=binary &lt; \/backup\/mysqldump.sql\r\n# mysql -uroot -p\u30d1\u30b9\u30ef\u30fc\u30c9 fedora --default-character-set=binary &lt; \/backup\/fedoradump.sql\r\n# mysql -uroot -p\u30d1\u30b9\u30ef\u30fc\u30c9 nucleus --default-character-set=binary &lt; \/backup\/nucleusdump.sql\r\n# mysql -uroot -p\u30d1\u30b9\u30ef\u30fc\u30c9 taka --default-character-set=binary &lt; \/backup\/takadump.sql\r\n# mysql -uroot -p\u30d1\u30b9\u30ef\u30fc\u30c9 centos --default-character-set=binary &lt; \/backup\/centosdump.sql\r\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\r\n[root@server1 ~]# \/etc\/init.d\/mysql restart<\/pre>\n<p><b>5.mysqldump\u306e\u4e16\u4ee3\u7ba1\u7406<\/b><br \/>\nmysqldump\u3067\u500b\u5225\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3057\u3066\u4e16\u4ee3\u7ba1\u7406\u3057\u305f\u3044\u5834\u5408<\/p>\n<pre>[root@server1 ~]# vi mysqlbackup.sh\r\n#!\/bin\/bash\r\n# \u8a8d\u8a3c\u60c5\u5831\r\nDBUSER=\"root\";\r\nDBPASSWD=\"\u30d1\u30b9\u30ef\u30fc\u30c9\";\r\n# \u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u5148\u30c7\u30a3\u30ec\u30af\u30c8\u30ea \/backup\/mysql\/130524 \u3068\u306a\u308b\u3002\r\nBAKDIR=\"\/backup\/mysql\";\r\nTODAYS_BAKDIR=\"$BAKDIR\/`date +%y%m%d`\";\r\n# DB\u4e00\u89a7\r\nDATABASES=`mysql -NB -u$DBUSER -p$DBPASSWD -e 'show databases'|egrep -vi 'information_schema|performance_schema'`;\r\n# \u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u5148\u304c\u306a\u3051\u308c\u3070\u4f5c\u6210\r\n[ ! -d $TODAYS_BAKDIR ] &amp;&amp; mkdir -p $TODAYS_BAKDIR;\r\n# DB\u540d\u3067\u30eb\u30fc\u30d7\u3001\u30c0\u30f3\u30d7\u53d6\u5f97\r\nfor DB in $DATABASES; do\r\nmysqldump -u$DBUSER -p$DBPASSWD --opt --events --default-character-set=binary --skip-lock-tables $DB &gt; $TODAYS_BAKDIR\/$DB.dump.sql;\r\ndone;\r\n# 3 \u65e5\u3088\u308a\u53e4\u3044\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u306f\u524a\u9664\r\nfind $BAKDIR -type d -mtime +3 -print0 | xargs -0 rm -rf;\r\n<\/pre>\n<p>\u3053\u308c\u3092\u6bce\u65e51:00\u306b\u81ea\u52d5\u5b9f\u884c\u3055\u305b\u308b<\/p>\n<pre>[root@server1 ~]# echo \"15 2 * * * root \/root\/mysqlbackup.sh\" &gt; \/etc\/cron.d\/mysqlbackup\r\n<\/pre>\n<div align=\"right\"><a href=\"#\">\u25b2 \u30da\u30fc\u30b8\u30c8\u30c3\u30d7\u3078<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\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 &hellip; <a href=\"http:\/\/yokensaka.com\/centos\/?p=65\">\u7d9a\u304d\u3092\u8aad\u3080 <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[27],"tags":[],"class_list":["post-65","post","type-post","status-publish","format-standard","hentry","category-27"],"_links":{"self":[{"href":"http:\/\/yokensaka.com\/centos\/index.php?rest_route=\/wp\/v2\/posts\/65","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/yokensaka.com\/centos\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/yokensaka.com\/centos\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/yokensaka.com\/centos\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/yokensaka.com\/centos\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=65"}],"version-history":[{"count":17,"href":"http:\/\/yokensaka.com\/centos\/index.php?rest_route=\/wp\/v2\/posts\/65\/revisions"}],"predecessor-version":[{"id":566,"href":"http:\/\/yokensaka.com\/centos\/index.php?rest_route=\/wp\/v2\/posts\/65\/revisions\/566"}],"wp:attachment":[{"href":"http:\/\/yokensaka.com\/centos\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=65"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/yokensaka.com\/centos\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=65"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/yokensaka.com\/centos\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=65"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}