{"id":1194,"date":"2017-10-14T09:53:54","date_gmt":"2017-10-14T00:53:54","guid":{"rendered":"http:\/\/blue-bear.jp\/kb\/?p=1194"},"modified":"2017-12-16T14:07:54","modified_gmt":"2017-12-16T05:07:54","slug":"wordpress-%e3%83%ad%e3%83%bc%e3%82%ab%e3%83%abmysql%e3%81%8b%e3%82%89aws-rds%e3%81%b8%e3%81%ae%e5%bc%95%e3%81%a3%e8%b6%8a%e3%81%97%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"https:\/\/blue-bear.jp\/kb\/wordpress-%e3%83%ad%e3%83%bc%e3%82%ab%e3%83%abmysql%e3%81%8b%e3%82%89aws-rds%e3%81%b8%e3%81%ae%e5%bc%95%e3%81%a3%e8%b6%8a%e3%81%97%e6%96%b9%e6%b3%95\/","title":{"rendered":"[wordpress] \u30ed\u30fc\u30ab\u30ebmysql\u304b\u3089AWS RDS\u3078\u306e\u5f15\u3063\u8d8a\u3057\u65b9\u6cd5"},"content":{"rendered":"<p>wordpress\u306e\u30ed\u30fc\u30ab\u30ebmysql\u3092AWS RDS\u3078\u5f15\u3063\u8d8a\u3057\u3059\u308b\u65b9\u6cd5\u306f\u4ee5\u4e0b\u306e\u901a\u308a<\/p>\n<p>\uff11\uff0eAWS\u4e0a\u3067Mysql\u306eRDS\u3092\u4f5c\u6210\uff08\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u540d\u3001\u30c6\u30fc\u30d6\u30eb\u540d(wordpress\u306a\u3069)\u3001ID\u3001\u30d1\u30b9\u30ef\u30fc\u30c9\u306a\u3069\u3082\u8a2d\u5b9a\u3057\u3066\u304a\u304f\uff09<\/p>\n<p>\uff12\uff0eRDS\u7528\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30b0\u30eb\u30fc\u30d7\u3092\u4f5c\u6210\u3057\u3066RDS\u306b\u30a2\u30bf\u30c3\u30c1\uff08in-bound TCP 3306\u3092\u8a31\u53ef\u3059\u308b\u3088\u3046\u306b\uff09<\/p>\n<p>\uff13\uff0eRDS\u3092\u4f5c\u6210\u3057\u305f\u3089\u3001\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u540d\u3092\u63a7\u3048\u308b<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1195\" src=\"http:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2017\/10\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2017-10-14-9.40.47-300x125.png\" alt=\"\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8 2017-10-14 9.40.47\" width=\"300\" height=\"125\" srcset=\"https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2017\/10\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2017-10-14-9.40.47-300x125.png 300w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2017\/10\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2017-10-14-9.40.47-768x321.png 768w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2017\/10\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2017-10-14-9.40.47-1024x427.png 1024w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2017\/10\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2017-10-14-9.40.47.png 1428w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>\uff14\uff0emysqldump\u30b3\u30de\u30f3\u30c9\u3067\u30ed\u30fc\u30ab\u30eb\u306e\u30c7\u30fc\u30bf\u3092\u30a8\u30af\u30b9\u30dd\u30fc\u30c8<\/p>\n<pre class=\"\">mysqldump -u root -p [table\u540d] &gt; backup.sql<\/pre>\n<p>\uff15\uff0emysql\u30b3\u30de\u30f3\u30c9\u3067RDS\u306b\u5148\u7a0b\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3057\u305fsql\u30c7\u30fc\u30bf\u3092\u30a4\u30f3\u30dd\u30fc\u30c8<\/p>\n<pre class=\"\">mysql -u [RDStable\u306e\u30e6\u30fc\u30b6\u540d] -p -h [RDS\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8] -D [\u5148\u7a0b\u4f5c\u6210\u3057\u305ftable\u540d] &lt; backup.sql<\/pre>\n<p>\uff16\uff0ewp-config.php\u5185\u306eDB\u30a2\u30af\u30bb\u30b9\u60c5\u5831\u3092RDS\u306e\u3082\u306e\u306b\u5909\u66f4\u3059\u308b<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1196\" src=\"http:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2017\/10\/migrate-database-rds-17-49701cf1-300x193.png\" alt=\"migrate-database-rds-17-49701cf1\" width=\"300\" height=\"193\" srcset=\"https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2017\/10\/migrate-database-rds-17-49701cf1-300x193.png 300w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2017\/10\/migrate-database-rds-17-49701cf1-768x493.png 768w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2017\/10\/migrate-database-rds-17-49701cf1-1024x657.png 1024w, https:\/\/blue-bear.jp\/kb\/wp-content\/uploads\/2017\/10\/migrate-database-rds-17-49701cf1.png 1131w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>\u5143\u306b\u623b\u3059\u306b\u306f\u3001\u9006\u306e\u3053\u3068\u3092\u3059\u308c\u3070OK<\/p>\n<p>RDS\u306b\u4ee5\u964d\u3057\u305f\u969b\u3001\u4e0b\u8a18\u30b5\u30a4\u30c8\u3092\u53c2\u8003\u306b\u30ed\u30fc\u30ab\u30ebmysql\u3092disable\u306b\u3057\u3066\u3044\u305f\u306e\u3092\u5fd8\u308c\u3066\u5143\u306e\u30ed\u30fc\u30ab\u30ebmysql\u306b\u623b\u3059\u6642\u306b\u30cf\u30de\u3063\u305f\u306e\u3067\u30e1\u30e2<\/p>\n<p><iframe class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" title=\"AWS bitnami wordpress\u306emysql\u306e\u30c0\u30f3\u30d7\u3001amazon RDS\u3078\u306e\u79fb\u884c\u30b3\u30de\u30f3\u30c9 - suzuki_kuni&#039;s blog\" src=\"https:\/\/hatenablog-parts.com\/embed?url=http%3A%2F%2Fk-suzuki.hateblo.jp%2Fentry%2F2016%2F10%2F26%2F154001#?secret=XhPg0j1vzk\" data-secret=\"XhPg0j1vzk\" scrolling=\"no\" frameborder=\"0\"><\/iframe><\/p>\n<h2>Can&#8217;t connect to local MySQL server through socket &#8216;\/tmp\/mysql.sock\u30a8\u30e9\u30fc<\/h2>\n<p>\u30ed\u30fc\u30ab\u30eb\u306eMysql\u306b\u30a2\u30af\u30bb\u30b9\u3057\u3088\u3046\u3068\u3059\u308b\u3068<\/p>\n<pre>Can't connect to local MySQL server through socket '\/tmp\/mysql.sock<\/pre>\n<p>\u3068\u3044\u3046\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u3066\u30a2\u30af\u30bb\u30b9\u3067\u304d\u306a\u304b\u3063\u305f\u3002<\/p>\n<p>\u7d50\u5c40\u306f\u3001bitnami\u306e\/opt\/bitnami\/mysql\/scripts\/ctl.sh\u3092disable\u306b\u3057\u3066\u3044\u305f\u306e\u3060\u304c\u3001\u3001<\/p>\n<p>\u30a8\u30e9\u30fc\u304c\u51fa\u305f\u5834\u5408\u306fmysql\u81ea\u4f53\u304c\u52d5\u4f5c\u3057\u3066\u3044\u306a\u3044\u3053\u3068\u304c\u7591\u308f\u308c\u308b\u305f\u3081<\/p>\n<pre>ps aux | grep mysql<\/pre>\n<p>\u3067mysql\u304c\u8d77\u52d5\u3057\u3066\u3044\u308b\u304b\u3092\u78ba\u8a8d\u3059\u308b\u3053\u3068<\/p>\n<p>bitnami\u3067mysql\u3092\u8d77\u52d5\u3055\u305b\u308b\u306b\u306f<\/p>\n<pre>sudo \/opt\/bitnami\/ctlscript.sh stop mysql<\/pre>\n<p>\u3067\u8d77\u52d5\u3067\u304d\u308b\u3002\u30b3\u30de\u30f3\u30c9\u3092\u5165\u529b\u3057\u3066\u3082\u4f55\u3082\u53cd\u5fdc\u3057\u306a\u3044\u5834\u5408\u306f\u3001\/opt\/bitnami\/mysql\/scripts\/ctl.sh\u304c\u5b58\u5728\u3059\u308b\u304b\u3092\u78ba\u8a8d\u3002\u5225\u306e\u540d\u524d\u306b\u306a\u3063\u3066\u3044\u305f\u3089\u3001\u5143\u306e\u540d\u524d\u306b\u623b\u3057\u3066\u3042\u3052\u308b\u3053\u3068\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>wordpress\u306e\u30ed\u30fc\u30ab\u30ebmysql\u3092<\/p>\n","protected":false},"author":1,"featured_media":1196,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,7],"tags":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/blue-bear.jp\/kb\/wp-json\/wp\/v2\/posts\/1194"}],"collection":[{"href":"https:\/\/blue-bear.jp\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blue-bear.jp\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blue-bear.jp\/kb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blue-bear.jp\/kb\/wp-json\/wp\/v2\/comments?post=1194"}],"version-history":[{"count":2,"href":"https:\/\/blue-bear.jp\/kb\/wp-json\/wp\/v2\/posts\/1194\/revisions"}],"predecessor-version":[{"id":1328,"href":"https:\/\/blue-bear.jp\/kb\/wp-json\/wp\/v2\/posts\/1194\/revisions\/1328"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blue-bear.jp\/kb\/wp-json\/wp\/v2\/media\/1196"}],"wp:attachment":[{"href":"https:\/\/blue-bear.jp\/kb\/wp-json\/wp\/v2\/media?parent=1194"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blue-bear.jp\/kb\/wp-json\/wp\/v2\/categories?post=1194"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blue-bear.jp\/kb\/wp-json\/wp\/v2\/tags?post=1194"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}