{"id":268,"date":"2016-06-01T01:00:16","date_gmt":"2016-05-31T16:00:16","guid":{"rendered":"http:\/\/now0930.iptime.org\/wordpress\/?p=268"},"modified":"2016-06-01T01:00:16","modified_gmt":"2016-05-31T16:00:16","slug":"bash-%ec%8a%a4%ed%81%ac%eb%a6%bd%ed%8a%b8%eb%a1%9c-%ec%82%ac%ec%a7%84%ec%a0%95%eb%b3%b4%eb%a5%bc-mysql%eb%a1%9c-%ec%97%85%eb%8d%b0%ec%9d%b4%ed%8a%b8","status":"publish","type":"post","link":"https:\/\/now0930.pe.kr\/wordpress\/bash-%ec%8a%a4%ed%81%ac%eb%a6%bd%ed%8a%b8%eb%a1%9c-%ec%82%ac%ec%a7%84%ec%a0%95%eb%b3%b4%eb%a5%bc-mysql%eb%a1%9c-%ec%97%85%eb%8d%b0%ec%9d%b4%ed%8a%b8\/","title":{"rendered":"bash \uc2a4\ud06c\ub9bd\ud2b8\ub85c \uc0ac\uc9c4\uc815\ubcf4\ub97c mysql\ub85c \uc5c5\ub370\uc774\ud2b8"},"content":{"rendered":"<p>\uba87\uac1c\uc6d4\uc804\uc5d0 LAMP\ub85c \ud734\ub300\ud3f0\uc73c\ub85c \ucc0d\uc740 \ub2e4\uc218\uc758 \uc0ac\uc9c4\uc744 \uad00\ub9ac\ud558\ub294 \ud398\uc774\uc9c0\ub97c \ub9cc\ub4e4\uc5c8\ub2e4. \uc77c\uc815 \uae30\uac04\uc774\ud6c4 \uc0ac\uc9c4\uc744 \uc5b4\ub290 \ud3f4\ub354\ub85c \uc774\ub3d9\ud6c4, JPG\uc758 EXIF\uc5d0 \ub300\ud55c \uc815\ubcf4\ub97c \ud30c\uc77c\ub85c \ubf51\uc544\ub0b4\uc5b4\uc11c, \ub0b4\uac00 \uc124\uc815\ud55c DB\ud615\uc2dd\uc5d0 \ub9de\ucdb0 \ucd94\uac00\ub97c \ud574\uc918\uc57c \ub418\ub294\ub370 \uc774\uac8c \uc880 \ub178\uac00\ub2e4\uc131\uc774 \uc788\ub2e4.<\/p>\n<p>\uc774\ub97c \ud574\uacb0\ud558\uae30 \uc704\ud574\uc11c \uc778\ud130\ub137 \ub4a4\uc838\uc11c \uc544\ub798\uc640 \uac19\uc740 \uc2a4\ud06c\ub9bd\uc744 \ub9cc\ub4e4\uc5c8\ub2e4. cron\uc5d0 \ub4f1\ub85d\ud574\uc11c \ud558\ub8e8\uc5d0 \ud55c\ubc88\uc529 \ud574\uc8fc\uba74 \ub420\uac83 \uac19\uc740\ub370, mysql \uc11c\ube44\uc2a4\uc5d0 \ud328\uc2a4\uc6cc\ub4dc\ub97c \uce58\ub294 \ubd80\ubd84\uc744 \uc0ac\uc6a9\uc790 \uc785\ub825\uc744 \uae30\ub2e4\ub9ac\uc9c0 \uc54a\uace0 \uc790\ub3d9\uc73c\ub85c \ud574\uc918\uc57c \ub418\ub294\ub370, \uc544\uc9c1 \uad6c\ud604\ud558\uc9c0 \ubabb\ud588\ub2e4. \ub098\uc911\uc5d0 \ubcf4\uc644\ud558\uba74 \ub418\ub294\ub370 \uc5b8\uc81c \ud560\uc9c0 \ubaa8\ub974\uaca0\ub2e4.<\/p>\n<pre class=\"lang:sh decode:true\" title=\"\uc77c\uc815\uae30\uac04 \uc0ac\uc9c4\uc758 \uc790\ub3d9 \uc5c5\ub370\uc774\ud2b8\">#!\/bin\/bash\r\nmytemp=$(mktemp);\r\nmytemp2=$(mktemp);\r\n#mytemp3=$(mktemp);\r\nfilelist=$(mktemp);\r\nrm $1;\r\nrm \ub370\uc774\ud130;\r\nmysql -D myHome -u now0930 -p -e \"select \ub0a0\uc790 from picture order by \ub0a0\uc790 desc limit 10\" &amp;gt; $mytemp;\r\n#cat $mytemp;\r\n\r\n#head -2 $mytemp;\r\n#sed -n 2p $mytemp &amp;gt; $mytemp2;\r\n\r\n#mysql\uc5d0\uc11c \ub9c8\uc9c0\ub9c9\uc73c\ub85c \uc5c5\ub370\uc774\ud2b8\ud55c \ub0a0\uc9dc\ub97c \ucd94\ucd9c\ud574\uc11c \ubcc0\uc218\ub85c \uae30\ub85d\r\nfrom=$(sed -n 2p $mytemp | cut -d' ' -f1);\r\nnext_from=$(date +%Y-%m-%d -d \"$from + 1 day\");\r\necho \"\ud504\ub86c:\"$from;\r\necho \"\ub2e4\uc74c\ub0a0:\"$next_from;\r\n#sleep 100;\r\ncat $mytemp2;\r\n#cut -d ' ' -f1 $mytemp2 &amp;gt; $mytemp3;\r\n#cat $mytemp3;\r\n\r\n#\ud604\uc7ac \ub0a0\uc9dc\ub97c \ubcc0\uc218\ub85c \uae30\ub85d\r\nnow=$(date +%Y-%m-%d);\r\necho $now;\r\n\r\n#start,end\ub97c \uc9c0\uc6c0..\r\nrm start now;\r\n\r\n#mysql\uc758 \ub9c8\uc9c0\ub9c9 \ub0a0\uc9dc\ub85c touch\ub97c \uc0ac\uc6a9\ud574\uc11c \ub9cc\ub4e6.\r\ntouch --date $next_from .\/start\r\ntouch --date $now .\/now\r\n\r\necho \"start, now \ub9cc\ub4e4\uc5b4\uc9d0\";\r\nfind ~\/ExtHDD\/pictureToWWW\/20151110\/ -type f -newer .\/start ! -newer .\/now \\\r\n| grep -v \uc9c0\uc6b8\ud3f4\ub354 | grep -ie \"jpg\\|JPG\\|jpeg\" &amp;gt; $1;\r\necho \"\ud30c\uc77c \ucc3e\uc544\uc9d0\";\r\n\r\n#find .\/ -type f -iname \"*jpg\" -o -iname \"*mp4\"\\\r\n# -newer .\/start -not -newer .\/now &amp;gt; $filelist;\r\n\r\n#echo $filelist;\r\n\r\n# JPG \ud30c\uc77c\uc744 \uc785\ub825 \ubc1b\uc544\uc11c meta \ub370\uc774\ud130\ub97c \ucd9c\ub825\ud558\ub294 \uc2a4\ud06c\ub9bd\ud2b8..\r\n\r\n#1\ubc88\uc9f8 \uc778\uc790..JPG\uac00 \uc785\ub825\ub418\uc5b4 \uc788\ub294 \ud30c\uc77c\uba85..\r\n\r\ncat $1 |\\\r\nwhile read CMD; do\r\n\r\n###############\r\n#\ub8e8\ud504\uc758 \uc2dc\uc791..\r\n################\r\n\r\n#ls\r\n#eval \"exiv2 -ps $1 &amp;gt; temp\"\r\necho \"\ud30c\uc77c\uba85 \ud655\uc778\ubd80\";\r\necho $CMD\r\necho `exiv2 -ps $CMD &amp;gt; temp`\r\necho \"\uc5ec\uae30\uc11c \uc2e4\ud589\ud655\uc778\"\r\necho `cat temp`\r\neval \"awk '\/File name\/{print $4}' temp &amp;gt; \ud30c\uc77c\uba85\";\r\n#filename=$(echo `awk 'BEGIN{FS=\"\\\/\";}{print \"\/imageOtherPar\/\"\\$6\"\/\"\\$7}' temp`)\r\nfilename=$(awk 'BEGIN{FS=\"\/\";}{print \"\/imageOtherPar\/\"$6\"\/\"$7}' \ud30c\uc77c\uba85);\r\n\r\necho \"\ud30c\uc77c\uba85\"\r\necho $filename\r\necho \"\ud30c\uc77c\uba85 \ucd9c\ub825 \uc644\ub8cc\"\r\n\r\n#eval \"awk '\/File name\/{print \\$4}' temp\r\n#$filename = $eval \"awk '\/File name\/{print \\$4}' temp\"\r\n\r\n#eval \"exiv2 -px $1 &amp;gt; temp\"\r\necho `exiv2 -pa $CMD &amp;gt; temp`\r\n#eval \"awk 'BEGIN{print \\\"EXIF \ucd94\ucd9c\uae30\\\";FS=\\\" \\\";}\/subject\/{print \\$4,\\$5,\\$6;}' temp &amp;gt;&amp;gt; \ud30c\uc77c\uba85\"\r\ntag=$(eval \"awk '\/subject\/{print \\$4,\\$5,\\$6;}' temp\")\r\nwidth=$(eval \"awk 'BEGIN{FS=\\\" \\\";}\/Image\\.ImageWidth\/{print \\$4}' temp\")\r\nheight=$(eval \"awk 'BEGIN{FS=\\\" \\\";}\/Image\\.ImageHeight\/{print \\$4}' temp\")\r\nif [$height -eq \"\"]\r\nthen\r\nheight=$(eval \"awk \/'Image\\.ImageLength\/{print \\$4}' temp\")\r\nfi\r\n\r\ndate=$(eval \"awk 'BEGIN{FS=\\\" \\\";}\/DateTimeOriginal\/{print \\$4}' temp\")\r\ntime=$(eval \"awk 'BEGIN{FS=\\\" \\\";}\/DateTimeOriginal\/{print \\$5}' temp\")\r\n#latitudeRef=$(eval \"awk 'BEGIN{FS=\\\" \\\";}\/GPSLatitudeRef\/{print \\$4}' temp\")\r\nlatitude=$(eval \"awk 'BEGIN{FS=\\\" \\\";}\/GPSLatitude\/{print \\$4}' temp\")\r\n#longitudeRef=$(eval \"awk 'BEGIN{FS=\\\" \\\";}\/GPSLongitudeRef\/{print \\$4}' temp\")\r\nlongitude=$(eval \"awk 'BEGIN{FS=\\\" \\\";}\/GPSLongitude\/{print \\$4}' temp\")\r\n\r\necho \"\ud14c\uc2a4\ud2b8 \uc601\uc5ed\"\r\necho \"width:\"$width\r\necho \"height:\"$height\r\necho \"\uc885\ud569\\n\"\r\necho $width $height $tag $date $time $latitudeRef $latitude $longitudeRef $longitude\r\n#echo $tag\r\n#$tag= $eval \"awk 'BEGIN{print \\\"EXIF \ucd94\ucd9c\uae30\\\";FS=\\\" \\\";}\/subject\/{print \\$4,\\$5,\\$6;}' temp\"\r\n#tag= $(awk 'BEGIN{print \\\"EXIF \ucd94\ucd9c\uae30\\\";FS=\" \";}\/subject\/{print \\$4,\\$5,\\$6;}' temp)\r\n#echo $tag\r\n\r\n#echo $filename $tag\r\n\r\necho -e $latitudeRef\r\necho -e $latitude\r\n\r\n#echo -e $filename \"\\t\" $tag \"\\t\" $date \"\\t\" $time \"\\t\" $width \"\\t\" $height \"\\t\" $latitudeRef \"\\t\" $latitude \"\\t\" $longitudeRef \"\\t\" $longitude\u00a0 &amp;gt;&amp;gt; \ub370\uc774\ud130\r\n\r\necho -e \" \\t\"$date\" \"$time\"\\t\"$tag\"\\t\"$filename\"\\t\"\"\uc774\ubbf8\uc9c0\\t\"$width\"\\t\"$height\"\\t\"$latitude\"\\t\"$longitude\"\\t\"\u00a0 &amp;gt;&amp;gt; \ub370\uc774\ud130\r\necho -e \"\ub108\ube44\" $width \"\ub192\uc774\" $height\r\necho \"\" &amp;gt; temp\r\ndone\r\n\r\n###############\r\n#\ub8e8\ud504\uc758 \ub05d...\r\n################\r\n\r\n#echo $mytemp;\r\nrm $mytemp;\r\nrm $mytemp2;\r\n#rm $mytemp3;\r\nrm $filelist;\r\n\r\n#\uc544\ub798\ub294 mysql\uc73c\ub85c \uc5c5\ub370\uc774\ud2b8 \ud558\ub294 \ubd80\ubd84..\r\n#home \ub514\ub809\ud1a0\ub9ac\uc758 .my.cnf\ud30c\uc77c\uc744 \ucc38\uc870\ud574\uc11c\r\n#\uc790\ub3d9\uc73c\ub85c \uc5c5\ub370\uc774\ud2b8\r\nmysql --local_infile=1 myHome -e \"LOAD DATA LOCAL INFILE '\ub370\uc774\ud130' INTO TABLE picture CHARACTER SET UTF8 FIELDS TERMINATED BY\u00a0 '\\t' \"<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uba87\uac1c\uc6d4\uc804\uc5d0 LAMP\ub85c \ud734\ub300\ud3f0\uc73c\ub85c \ucc0d\uc740 \ub2e4\uc218\uc758 \uc0ac\uc9c4\uc744 \uad00\ub9ac\ud558\ub294 \ud398\uc774\uc9c0\ub97c \ub9cc\ub4e4\uc5c8\ub2e4. \uc77c\uc815 \uae30\uac04\uc774\ud6c4 \uc0ac\uc9c4\uc744 \uc5b4\ub290 \ud3f4\ub354\ub85c \uc774\ub3d9\ud6c4, JPG\uc758 EXIF\uc5d0 \ub300\ud55c \uc815\ubcf4\ub97c \ud30c\uc77c\ub85c [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[12],"tags":[14,13,15],"class_list":["post-268","post","type-post","status-publish","format-standard","hentry","category-12","tag-bash","tag-mysql","tag-15"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/posts\/268","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/comments?post=268"}],"version-history":[{"count":7,"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/posts\/268\/revisions"}],"predecessor-version":[{"id":275,"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/posts\/268\/revisions\/275"}],"wp:attachment":[{"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/media?parent=268"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/categories?post=268"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/tags?post=268"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}