{"id":2434,"date":"2016-05-13T10:22:05","date_gmt":"2016-05-13T01:22:05","guid":{"rendered":"http:\/\/www.whoocus.com\/blog\/?p=2434"},"modified":"2016-05-13T10:23:36","modified_gmt":"2016-05-13T01:23:36","slug":"redmine%e3%83%90%e3%83%83%e3%82%af%e3%82%a2%e3%83%83%e3%83%97%e3%82%b9%e3%82%af%e3%83%aa%e3%83%97%e3%83%88","status":"publish","type":"post","link":"https:\/\/www.blowfish.co.jp\/?p=2434","title":{"rendered":"Redmine\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u30b9\u30af\u30ea\u30d7\u30c8"},"content":{"rendered":"<p>[bash]<br \/>\n#!\/bin\/sh<br \/>\n#<br \/>\n# Redmine DB backup script<br \/>\n# <\/p>\n<p>FILE_DIR=\/app\/redmine\/files\/<br \/>\nDMP_DIR=\/var\/tmp\/<br \/>\nMNT_DIR=\/mnt\/rm\/<br \/>\nBAK_DIR=&quot;\/\/10.0.0.0\/windows\/Backup\/dir\/rm&quot;<br \/>\nPERIOD=5<br \/>\nDB_USER=dbuser<br \/>\nDB_PASS=xxxxxx<\/p>\n<p>USER_NAME=username<br \/>\nPASSWD=xxxxxxx<br \/>\nEXIT_STATUS=0<\/p>\n<p>FILE_NAME=`date +%y%m%d`<br \/>\nRM_FILE_NAME=`date &#8211;date &quot;$PERIOD days ago&quot; +%y%m%d`<\/p>\n<p>DMP_FILE=$DMP_DIR\/Redmine_DB_$FILE_NAME.sql.gz<br \/>\nARC_FILE=$DMP_DIR\/Redmine_FILE_$FILE_NAME.tar.gz<\/p>\n<p>RM_DMP_FILE=$MNT_DIR\/Redmine_DB_$RM_FILE_NAME.sql.gz<br \/>\nRM_ARC_FILE=$MNT_DIR\/Redmine_FILE_$RM_FILE_NAME.tar.gz<\/p>\n<p># \u30d5\u30a1\u30a4\u30eb\u30b5\u30fc\u30d0\u3078\u30de\u30a6\u30f3\u30c8<br \/>\nmount -t cifs -o username=$USER_NAME,password=$PASSWD $BAK_DIR $MNT_DIR<\/p>\n<p># \u30c7\u30fc\u30bf\u306e\u30c0\u30f3\u30d7<br \/>\nmysqldump &#8211;opt &#8211;single-transaction &#8211;default-character-set=binary -u $DB_USER &#8211;password=$DB_PASS &#8211;all-databases | gzip &gt; $DMP_FILE<br \/>\necho &quot;Redmine DB Backup OK&quot;<\/p>\n<p># \u6dfb\u4ed8\u30d5\u30a1\u30a4\u30eb\u306e\u30a2\u30fc\u30ab\u30a4\u30d6<br \/>\ntar cfvz $ARC_FILE $FILE_DIR<br \/>\necho &quot;Redmine Files Backup OK&quot;<\/p>\n<p># \u30d5\u30a1\u30a4\u30eb\u306e\u79fb\u52d5<br \/>\nmv $DMP_FILE $MNT_DIR<br \/>\nmv $ARC_FILE $MNT_DIR<br \/>\necho &quot;Redmine Files Move to Server OK&quot;<\/p>\n<p># \u30d5\u30a1\u30a4\u30eb\u306e\u524a\u9664<br \/>\nrm $RM_DMP_FILE<br \/>\nrm $RM_ARC_FILE<br \/>\necho &quot;Redmine Files Cleanup OK&quot;<\/p>\n<p>umount -l $MNT_DIR<\/p>\n<p>exit $EXIT_STATUS<br \/>\n[\/bash]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>[bash] #!\/bin\/sh # # Redmine DB backup script # FILE_DIR=\/app\/redmine\/files\/ DMP_DIR=\/var\/tmp\/ MNT_DIR=\/mnt\/rm [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"saved_in_kubio":false,"footnotes":""},"categories":[4],"tags":[],"class_list":["post-2434","post","type-post","status-publish","format-standard","hentry","category-tech"],"_links":{"self":[{"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/2434","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2434"}],"version-history":[{"count":2,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/2434\/revisions"}],"predecessor-version":[{"id":2436,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/2434\/revisions\/2436"}],"wp:attachment":[{"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2434"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2434"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2434"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}