{"id":3,"date":"2009-02-10T00:00:13","date_gmt":"2009-02-09T15:00:13","guid":{"rendered":"http:\/\/www.kuroneko-square.net\/articles\/?p=3"},"modified":"2009-09-21T23:33:16","modified_gmt":"2009-09-21T14:33:16","slug":"20090210","status":"publish","type":"post","link":"https:\/\/www.kuroneko-square.net\/articles\/20090210","title":{"rendered":"\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u306e\u4fdd\u5b58\u671f\u9593\u3092\u5ef6\u9577"},"content":{"rendered":"

\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u306e\u4fdd\u5b58\u671f\u9593\u3092\u5ef6\u9577\u3057\u3001\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u74b0\u5883\u3092\u5f37\u5316\u3057\u307e\u3057\u305f\u3002cron\u306b\u3066\u5b9a\u6642\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3092\u3068\u308a\u3001\u3055\u3089\u306b\u6570\u65e5\u5206\u3092\u6b8b\u3059\u3088\u3046\u306b\u3057\u307e\u3057\u305f\u3002<\/p>\r\n

\u3068\u3053\u308d\u3067\u3001MySQL\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u7528\u30b9\u30af\u30ea\u30d7\u30c8\u3068\u3057\u3066\u3001AutoMySQLBackup<\/a>\u3068\u3044\u3046\u306e\u304c\u3042\u308a\u307e\u3057\u305f\u3002\u624b\u8efd\u306b\u4f7f\u3048\u3066\u3044\u3044\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u306d\u3002<\/p>\r\n\r\n

\u4ee5\u4e0b\u306fcron\u3067MySQL\u3092\u5b9a\u671f\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3059\u308b\u305f\u3081\u306e\u899a\u3048\u66f8\u304d\u3067\u3059\u3002<\/p>\n\n

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
<\/div><\/td>
#!\/bin\/sh<\/span>
\n
\n# MySQL Backup<\/span>
\n# Remains at least these days<\/span>
\nkeepday<\/span>=14<\/span>
\n
\n# Settings<\/span>
\ndest<\/span>=$HOME<\/span>\/<\/span>backup_mysql
\ntmp<\/span>=$HOME<\/span>\/<\/span>tmp
\nsrcfile<\/span>=mysql.dump
\nuser<\/span>=user
\ndb<\/span>=dbname
\n
\n# Dump<\/span>
\n\/<\/span>usr\/<\/span>local\/<\/span>mysql\/<\/span>bin\/<\/span>mysqldump -u<\/span> root --password<\/span>='\u30d1\u30b9\u30ef\u30fc\u30c9'<\/span> --opt<\/span> \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d ><\/span> \/*****\/<\/span>backup\/<\/span>temp
\n
\n# Get timestamp<\/span>
\ntimestamp<\/span>=`<\/span>date<\/span> +%<\/span>Y%<\/span>m%<\/span>d`<\/span>
\nold_date<\/span>=`<\/span>date<\/span> "-d$keepday<\/span> days ago"<\/span> +%<\/span>Y%<\/span>m%<\/span>d`<\/span>
\n
\nbkfile<\/span>=$dest<\/span>\/<\/span>$srcfile<\/span>-$timestamp<\/span>.tar.gz
\n
\ncd<\/span> $tmp<\/span>; tar<\/span> zcvf $bkfile<\/span> $srcfile<\/span>
\ncd<\/span> $HOME<\/span>
\n# > \/dev\/null 2>&1<\/span>
\n
\nif<\/span> [<\/span> $?<\/span> !<\/span>= 0<\/span> -o<\/span> !<\/span> -e<\/span> $bkfile<\/span> ]<\/span>; then<\/span>
\necho<\/span> "backup faild -- ($tmp<\/span>\/$srcfile<\/span>)"<\/span>
\nexit<\/span> 1<\/span>
\nfi<\/span>
\n
\nrmfile<\/span>=$dest<\/span>\/<\/span>$srcfile<\/span>-$old_date<\/span>.tar.gz
\n
\nif<\/span> [<\/span> -e<\/span> $rmfile<\/span> ]<\/span>; then<\/span>
\nrm<\/span> -f<\/span> $rmfile<\/span>
\nfi<\/span>
\n
\nrm<\/span> -f<\/span> $tmp<\/span>\/<\/span>$srcfile<\/span>
\n
\nexit<\/span><\/div><\/td><\/tr><\/tbody><\/table><\/div>\n\n","protected":false},"excerpt":{"rendered":"\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u306e\u4fdd\u5b58\u671f\u9593\u3092\u5ef6\u9577\u3057\u3001\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u74b0\u5883\u3092\u5f37\u5316\u3057\u307e\u3057\u305f\u3002cron\u306b\u3066\u5b9a\u6642\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3092\u3068\u308a\u3001\u3055\u3089\u306b\u6570\u65e5\u5206\u3092\u6b8b\u3059\u3088\u3046\u306b\u3057\u307e\u3057\u305f\u3002","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[14,7,3],"class_list":["post-3","post","type-post","status-publish","format-standard","hentry","category-blog","tag-cron","tag-7","tag-3"],"_links":{"self":[{"href":"https:\/\/www.kuroneko-square.net\/articles\/wp-json\/wp\/v2\/posts\/3","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.kuroneko-square.net\/articles\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.kuroneko-square.net\/articles\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.kuroneko-square.net\/articles\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kuroneko-square.net\/articles\/wp-json\/wp\/v2\/comments?post=3"}],"version-history":[{"count":1,"href":"https:\/\/www.kuroneko-square.net\/articles\/wp-json\/wp\/v2\/posts\/3\/revisions"}],"predecessor-version":[{"id":54,"href":"https:\/\/www.kuroneko-square.net\/articles\/wp-json\/wp\/v2\/posts\/3\/revisions\/54"}],"wp:attachment":[{"href":"https:\/\/www.kuroneko-square.net\/articles\/wp-json\/wp\/v2\/media?parent=3"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kuroneko-square.net\/articles\/wp-json\/wp\/v2\/categories?post=3"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kuroneko-square.net\/articles\/wp-json\/wp\/v2\/tags?post=3"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}