{"id":378,"date":"2010-06-14T18:51:02","date_gmt":"2010-06-14T09:51:02","guid":{"rendered":"https:\/\/blog.eldhrimnir.com?p=378"},"modified":"2010-06-17T01:58:56","modified_gmt":"2010-06-16T16:58:56","slug":"mysql-db%e3%83%90%e3%83%83%e3%82%af%e3%82%a2%e3%83%83%e3%83%97","status":"publish","type":"post","link":"https:\/\/blog.eldhrimnir.com\/?p=378","title":{"rendered":"MySQL-DB\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\uff08ServersMan@VPS\uff09"},"content":{"rendered":"<p>\u500b\u4eba\u30b5\u30a4\u30c8\u3060\u306824H365D\u306e\u7a3c\u50cd\u8981\u4ef6\u306f\u306a\u3044\u2026\u3002<br \/>\n\u30cf\u30ba\u306a\u306e\u3067\u4e00\u6642\u7684\u306b\u30aa\u30d5\u30e9\u30a4\u30f3\u306b\u3057\u3066\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3059\u308b\u65b9\u6cd5\u3068\u3061\u3083\u3093\u3068\u3057\u305f\u30aa\u30f3\u30e9\u30a4\u30f3\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u65b9\u6cd5<\/p>\n<h2>\u30aa\u30d5\u30e9\u30a4\u30f3\u30d0\u30c3\u30af\u30a2\u30c3\u30d7<\/h2>\n<p>\u00a01.MySQL\u30b5\u30fc\u30d0\u3092\u505c\u6b62\u3055\u305b\u308b\u3002<\/p>\n<p><span style=\"color: #000080;\"><strong>\u00a0# \/etc\/init.d\/mysqld stop<\/strong><\/span><br \/>\n\u00a02.MySQL\u306e\u30c7\u30fc\u30bf\u30d5\u30a1\u30a4\u30eb\u304a\u3088\u3073\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u3092\u30b3\u30d4\u30fc\u3068\u5727\u7e2e<br \/>\n\u00a0\u00a0\u4f8b\u3048\u3070\u3001MySQL\u306e\u30c7\u30fc\u30bf\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\/var\/lib\/mysql\u3092\/tmp\/mysql-backup\u306b\u4fdd\u5b58\u3059\u308b\u5834\u5408\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u306a\u308b\u3002<\/p>\n<p><span style=\"color: #000080;\"><strong>\u00a0# cp -r \/var\/lib\/mysql \/tmp\/mysql-backup<br \/>\n\u00a0# cd \/tmp\/mysql-backup<br \/>\n\u00a0# tar cvf mysql-backup_&lt;\u65e5\u4ed8&gt; mysql-backup<\/strong><\/span><br \/>\n\u00a03.MySQL\u30b5\u30fc\u30d0\u3092\u8d77\u52d5\u3057\u76f4\u3059\u3002<\/p>\n<p><span style=\"color: #000080;\"><strong># \/etc\/init.d\/mysqld start<\/strong><\/span><\/p>\n<blockquote><p><em>\u00a0\u00a0\u30fb\u30ea\u30b9\u30c8\u30a2\u65b9\u6cd5<br \/>\n\u00a0\u00a0# \/etc\/init.d\/mysqld stop<br \/>\n\u00a0\u00a0# cd \/tmp<br \/>\n\u00a0\u00a0# tar xvf mysql-backup_&lt;\u65e5\u4ed8&gt;<br \/>\n\u00a0\u00a0# cp -r \/tmp\/mysql-backup \/var\/lib\/mysql<\/em><\/p>\n<p><!--more--><\/p><\/blockquote>\n<h2>\u30aa\u30f3\u30e9\u30a4\u30f3\u30d0\u30c3\u30af\u30a2\u30c3\u30d7<\/h2>\n<p>\u00a01.\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30d0\u30c3\u30af\u30a2\u30c3\u30d7<\/p>\n<p><span style=\"color: #000080;\"><strong>mysqlhotcopy -u root &lt;\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d&gt; -p \/tmp\/mysql\uff08DB\u306eroot\u30d1\u30b9\u30ef\u30fc\u30c9\u5fc5\u8981\uff09<\/strong><\/span><br \/>\n\u00a0<br \/>\n\u00a02.\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u5727\u7e2e<br \/>\n\u00a0<br \/>\n\u00a0<span style=\"color: #000080;\"><strong># cd \/tmp\/<br \/>\n\u00a0# tar cvf mysql-backup_&lt;\u65e5\u4ed8&gt; mysql<\/strong><\/span><\/p>\n<p>\u00a0<span style=\"color: #808000;\"><strong>\u203b\uff1aWorkpress\u306eDB\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u306e\u5834\u5408\u306f&lt;\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d&gt;\u306f\u300cwordpress\u300d\u3068\u306a\u308b\u3002<\/strong><\/span><\/p>\n<blockquote><p><em>\u00a0\u00a0\u30fb\u30ea\u30b9\u30c8\u30a2\u65b9\u6cd5<br \/>\n\u00a0\u00a0# cd \/tmp\/<br \/>\n\u00a0\u00a0# tar xvf mysql-backup_&lt;\u65e5\u4ed8&gt;<br \/>\n\u00a0\u00a0# \/bin\/cp -Rf \/tmp\/mysql\/&lt;\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d&gt;\/ \/var\/lib\/mysql\/<br \/>\n\u00a0\u00a0# chown -R mysql:mysql \/var\/lib\/mysql\/&lt;\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d&gt;\/<br \/>\n\u00a0\u00a0# chmod 700 \/var\/lib\/mysql\/&lt;\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d&gt;\/<br \/>\n\u00a0\u00a0# chmod 660 \/var\/lib\/mysql\/&lt;\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d&gt;\/*<\/em><\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>\u500b\u4eba\u30b5\u30a4\u30c8\u3060\u306824H365D\u306e\u7a3c\u50cd\u8981\u4ef6\u306f\u306a\u3044\u2026\u3002 \u30cf\u30ba\u306a\u306e\u3067\u4e00\u6642\u7684\u306b\u30aa\u30d5\u30e9\u30a4\u30f3\u306b\u3057\u3066\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3059\u308b\u65b9\u6cd5\u3068\u3061\u3083\u3093\u3068\u3057\u305f\u30aa\u30f3\u30e9\u30a4\u30f3\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u65b9\u6cd5 \u30aa\u30d5\u30e9\u30a4\u30f3\u30d0\u30c3\u30af\u30a2\u30c3\u30d7 \u00a01.MySQL\u30b5\u30fc\u30d0\u3092\u505c\u6b62\u3055\u305b\u308b\u3002 \u00a0# \/et [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,9],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.eldhrimnir.com\/index.php?rest_route=\/wp\/v2\/posts\/378"}],"collection":[{"href":"https:\/\/blog.eldhrimnir.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.eldhrimnir.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.eldhrimnir.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.eldhrimnir.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=378"}],"version-history":[{"count":0,"href":"https:\/\/blog.eldhrimnir.com\/index.php?rest_route=\/wp\/v2\/posts\/378\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.eldhrimnir.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=378"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.eldhrimnir.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=378"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.eldhrimnir.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=378"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}