{"id":98,"date":"2013-01-16T22:30:30","date_gmt":"2013-01-16T13:30:30","guid":{"rendered":"http:\/\/atmark.ddo.jp\/blog\/?p=98"},"modified":"2013-01-16T22:30:30","modified_gmt":"2013-01-16T13:30:30","slug":"mysql%e3%81%a8php%e3%81%a8hdd","status":"publish","type":"post","link":"https:\/\/atmark.pgw.jp\/blog\/centos\/98.html","title":{"rendered":"MySQL\u3068php\u3068HDD"},"content":{"rendered":"<p>TinyTinyRSS\u3092\u5165\u308c\u3066\u304b\u3089\u3001HDD\u306e\u30ac\u30ea\u30ac\u30ea\u97f3\u304c\u3059\u308b\u306e\u3067\u3059\u304c\u3001\u4ed5\u65b9\u306a\u3044\u3068\u8ae6\u3081\u3066\u306f\u3044\u305f\u3082\u306e\u306e\u3001\u4f59\u308a\u306b\u3082\u3046\u308b\u3055\u3044\u306e\u3067\u3001MySQL\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u5225\u306eHDD\u3078\u79fb\u52d5\u3055\u305b\u308b\u3053\u3068\u306b\u3057\u307e\u3057\u305f\u3002<\/p>\n<p>\u79fb\u52d5\u65b9\u6cd5\u306f\u3001Google\u5148\u751f\u306b\u76f8\u8ac7\u3059\u308b\u3068\u51fa\u3066\u304f\u308b\u306e\u3067\u3001\u4eca\u56de\u306f\u65b9\u6cd5\u3060\u3051\u66f8\u3044\u305f\u5c0f\u30cd\u30bf\u3067\u3059\u3002<\/p>\n<p>&nbsp;<\/p>\n<p><!--more--><\/p>\n<blockquote style=\"background-color: black; color: white;\"><p>$ sudo service mysqld stop<br \/>\n$ sudo cp -rp \/var\/lib\/mysql \/mnt\/HDD\/<br \/>\n$ sudo mv \/var\/lib\/mysql \/var\/lib\/mysql_bak<br \/>\n$ sudo vim \/etc\/my.cnf<\/p>\n<p>[mysqld]<br \/>\n#datadir=\/var\/lib\/mysql<br \/>\n#socket=\/var\/lib\/mysql\/mysql.sock<br \/>\ndatadir=\/mnt\/ExHDD\/mysql<br \/>\nsocket=\/mnt\/ExHDD\/mysql\/mysql.sock<\/p>\n<p>#[Client]<br \/>\n#socket=\/mnt\/ExHDD\/mysql\/mysql.sock<\/p>\n<p>$ sudo service mysqld start<\/p><\/blockquote>\n<p>MySQL\u3092STOP\u5f8c\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u5225HDD\u3078\u30b3\u30d4\u30fc\u3057\u3066\u3044\u307e\u3059<br \/>\n\u30b3\u30d4\u30fc\u306e\u969b\u306fp\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u8ffd\u52a0\u3057\u3001\u5c5e\u6027\u3092\u7dad\u6301\u3057\u306a\u3044\u3068\u30a8\u30e9\u30fc\u306b\u306a\u308a\u307e\u3057\u305f\u3002\u3002\u3002<br \/>\n\u305d\u306e\u5f8c\u3001\u81ea\u5206\u306f\u30d3\u30d3\u30ea\u306a\u306e\u3067\u3001\u5143\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u30ea\u30cd\u30fc\u30e0\u3057\u3066\u304a\u3044\u3066\u307e\u3059\u3002\u306a\u306e\u3067\u3001\u81ea\u8eab\u306e\u3042\u308b\u4eba\u306f\u4e0d\u8981\u3067\u3059\u306d\u3002<\/p>\n<p>\u6b21\u306b\u3001\/etc\/my.cnf\u3092\u4fee\u6b63\u3002<br \/>\ndatadir\u3068socket\u306e\u884c\u3092\u5909\u66f4\u5f8c\u306e\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u3078\u5909\u66f4\u3057\u307e\u3059\u3002\u5143\u306e\u8a2d\u5b9a\u306f\u3084\u3063\u3071\u308a\u6016\u304c\u308a\u306a\u306e\u3067\u3001<br \/>\n#\u3067\u30b3\u30e1\u30f3\u30c8\u30a2\u30a6\u30c8\u3057\u3066\u307e\u3059<br \/>\n[Client]\u304b\u3089\u306e\u884c\u306f\u3001\u8ffd\u52a0\u3057\u306a\u3044\u3068\u30a8\u30e9\u30fc\u306b\u306a\u308b\u74b0\u5883\u304c\u3042\u308b\u3088\u3046\u3067\u3059\u3002<br \/>\n\u81ea\u5206\u306e\u74b0\u5883\u3067\u306f\u4e0d\u8981\u3067\u3057\u305f\u3002<\/p>\n<blockquote style=\"background-color: black; color: white;\"><p>$\u00a0sudo vim \/etc\/php.ini<\/p>\n<p>; Default socket name for local MySQL connects. If empty, uses the built-in<br \/>\n; MySQL defaults.<br \/>\n; http:\/\/www.php.net\/manual\/en\/mysql.configuration.php#ini.mysql.default-socket<br \/>\nmysql.default_socket = \/mnt\/ExHDD\/mysql\/mysql.sock<\/p>\n<p>$ sudo service httpd restart<br \/>\n$ sudo rm -f \/var\/lib\/mysql_bak<\/p><\/blockquote>\n<p>php\u306b\u5909\u66f4\u3092\u9069\u7528\u3057\u307e\u3059\u3002<br \/>\nphp.ini\u306bsocket\u306e\u5834\u6240\u3092\u8a18\u8ff0\u3057\u306a\u3044\u3068\u3001php\u304b\u3089MySQL\u3078\u30a2\u30af\u30bb\u30b9\u51fa\u6765\u306a\u304b\u3063\u305f\u306e\u3067\u3001\u4e0a\u8a18\u3092\u8ffd\u8a18\u3057\u3066\u3044\u307e\u3059\u3002<br \/>\n\u8ffd\u8a18\u5f8c\u3001httpd\u3092restart\u3002\u3002\u3002<\/p>\n<p>\u3059\u3079\u3066\u304c\u554f\u984c\u306a\u304f\u52d5\u4f5c\u3057\u3066\u3044\u308b\u4e8b\u3092\u78ba\u8a8d\u5f8c\u3001\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3092\u6d88\u3057\u3066\u7d42\u4e86\u3067\u3059\u3002<br \/>\n\u305f\u3076\u3093\u3001google\u5148\u751f\u304b\u3089\u51fa\u3066\u304f\u308b\u4ed6\u306e\u30da\u30fc\u30b8\u306e\u65b9\u3005\u306e\u65b9\u304c\u8a73\u3057\u304f\u89e3\u8aac\u3055\u308c\u3066\u3044\u308b\u3068\u601d\u3046\u306e\u3067\u3001\u8a73\u7d30\u306f\u305d\u3061\u3089\u3092\u53c2\u7167\u304f\u3060\u3055\u3044\u3002<\/p>\n<p>\u3061\u306a\u307f\u306b\u3001\/mnt\/ExHDD\u306f\u8d77\u52d5\u5f8c\u306b\/etc\/crontab\u3067\u81ea\u52d5\u7684\u306b\u30de\u30a6\u30f3\u30c8\u3057\u3066\u3044\u305f\u306e\u3067\u3059\u304c\u3001service\u3067MySQL\u3092\u8d77\u52d5\u3057\u3066\u3044\u308b\u5834\u5408\u3001reboot\u5f8c\u306bMySQL\u304c\u6b63\u5e38\u306b\u52d5\u3044\u3066\u3044\u307e\u305b\u3093\u3067\u3057\u305f\u3002<\/p>\n<p>\u81ea\u5206\u3067\u3082\u3080\u3061\u3083\u304f\u3061\u3083\u306a\u4e8b\u3084\u3063\u3066\u308b\u306a\u3041\u3002\u3068\u3001\u601d\u3063\u3066\u3044\u305f\u306e\u3067\u3059\u304c\u3001\u8981\u3059\u308b\u306bcrond\u306e\u8d77\u52d5\u524d\u306bmysqld\u304c\u8d77\u52d5\u3057\u3088\u3046\u3068\u3057\u3066\u8d77\u52d5\u3067\u304d\u3066\u3044\u306a\u304b\u3063\u305f\u3088\u3046\u3067\u3059\u3002<br \/>\n\u3053\u308c\u3092\u6c17\u306b\u3001\u3061\u3083\u3093\u3068\/etc\/fstab\u3067\u30de\u30a6\u30f3\u30c8\u3059\u308b\u3088\u3046\u306b\u4fee\u6b63\u3057\u307e\u3057\u305f\u3002\u3068\u308a\u3042\u3048\u305a\u3001\u3053\u308c\u3067\u554f\u984c\u306a\u3055\u305d\u3046\u3067\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>TinyTinyRSS\u3092\u5165\u308c\u3066\u304b\u3089\u3001HDD\u306e\u30ac\u30ea\u30ac\u30ea\u97f3\u304c\u3059\u308b\u306e\u3067\u3059\u304c\u3001\u4ed5\u65b9\u306a\u3044\u3068\u8ae6\u3081\u3066\u306f\u3044\u305f\u3082\u306e\u306e\u3001\u4f59\u308a\u306b\u3082\u3046\u308b\u3055\u3044\u306e\u3067\u3001MySQL\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u5225\u306eHDD\u3078\u79fb\u52d5\u3055\u305b\u308b\u3053\u3068\u306b\u3057\u307e\u3057\u305f\u3002 \u79fb\u52d5\u65b9\u6cd5\u306f\u3001Google\u5148\u751f\u306b\u76f8 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":76,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[11,23,29,45],"_links":{"self":[{"href":"https:\/\/atmark.pgw.jp\/blog\/wp-json\/wp\/v2\/posts\/98"}],"collection":[{"href":"https:\/\/atmark.pgw.jp\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/atmark.pgw.jp\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/atmark.pgw.jp\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/atmark.pgw.jp\/blog\/wp-json\/wp\/v2\/comments?post=98"}],"version-history":[{"count":0,"href":"https:\/\/atmark.pgw.jp\/blog\/wp-json\/wp\/v2\/posts\/98\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/atmark.pgw.jp\/blog\/wp-json\/wp\/v2\/media\/76"}],"wp:attachment":[{"href":"https:\/\/atmark.pgw.jp\/blog\/wp-json\/wp\/v2\/media?parent=98"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/atmark.pgw.jp\/blog\/wp-json\/wp\/v2\/categories?post=98"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/atmark.pgw.jp\/blog\/wp-json\/wp\/v2\/tags?post=98"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}