{"id":5824,"date":"2019-10-22T11:58:09","date_gmt":"2019-10-22T02:58:09","guid":{"rendered":"https:\/\/nsme.red\/wp\/?p=5824"},"modified":"2026-10-31T16:25:07","modified_gmt":"2026-10-31T07:25:07","slug":"mysqldump%e3%81%a8%e5%be%a9%e5%85%83","status":"publish","type":"post","link":"https:\/\/core.nsme.net\/notes\/mysql\/5824\/","title":{"rendered":"mysqldump\u3068\u5fa9\u5143"},"content":{"rendered":"\n

 \u7279\u5b9a\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u307f\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3059\u308b\u65b9\u6cd5<\/strong>
MySQL \u306e\u7279\u5b9a\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30c7\u30fc\u30bf\u3092 dump \u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3059\u308b\u306b\u306f\u3001\u6b21\u306e\u30b3\u30de\u30f3\u30c9\u3067\u884c\u3046\u3002$ mysqldump -u DB\u30e6\u30fc\u30b6\u540d -p DB\u540d > \u51fa\u529b\u5148\u30d5\u30a1\u30a4\u30eb\u540d<\/strong>
\u3000mysqldump -u terao -p sankyoSNS > \/var\/www\/vhosts\/nsm2.net\/sns.sql
mysqldump -u sns -p sns > \/home\/terao\/sns.sql<\/p>\n\n\n\n

\u7279\u5b9a\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u307f\u5fa9\u5143\u3059\u308b\u65b9\u6cd5<\/strong>
\u7279\u5b9a\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e dump \u30d5\u30a1\u30a4\u30eb\u3092\u3001\u7279\u5b9a\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u5fa9\u5143\u3059\u308b\u65b9\u6cd5\u306f\u6b21\u306e\u30b3\u30de\u30f3\u30c9\u3067\u3067\u304d\u307e\u3059\u3002 \u30c7\u30fc\u30bf\u306e\u6295\u5165\u5148\u3068\u306a\u308b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306f\u5148\u306b\u4f5c\u6210\u3057\u3066\u304a\u304f\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n

$ mysql -u \u30e6\u30fc\u30b6\u30fc\u540d -p<\/strong> \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d < dump\u30d5\u30a1\u30a4\u30eb\u540d<\/strong><\/p>\n\n\n\n

mysql -u terao -p sankyoSNS_test < \/var\/www\/vhosts\/nsm2.net\/sankyoSNS.sql
mysql -u terao -p sns_test < \/var\/www\/vhosts\/nsm2.net\/sns.sql
<\/p>\n\n\n\n

zcat\u30b3\u30de\u30f3\u30c9\u3092\u4f7f\u3063\u3066\u5bb9\u91cf\u306e\u5727\u8feb\u3092\u6291\u3048\u308b<\/a><\/p>\n\n\n\n

dump<\/h3>\n\n\n\n
mysqldump -u terao -p sankyoSNS | gzip > sns.sql.gz<\/code><\/pre>\n\n\n\n
<\/a>restore<\/h3>\n\n\n\n
zcat dumpfile.sql.gz | mysql -u username -ppassword database_name\nzcat sns.sql.gz | mysql -u terao -p sns<\/code><\/pre>\n\n\n\n
  \u3053\u306e\u65b9\u6cd5\u3060\u3068\u3001\u5de8\u5927\u30d5\u30a1\u30a4\u30eb\u306e\u5834\u5408\u30a8\u30e9\u30fc\u3067\u5fa9\u5143\u3067\u304d\u306a\u3044\u5834\u5408\u304c\u3042\u308b\u3002
\u5de8\u5927\u30d5\u30a1\u30a4\u30eb\u306e\u5834\u5408\u3001\u6b21\u306e\u65b9\u6cd5\u3092\u5229\u7528\u3059\u308b\u3002 <\/p>\n\n\n\n
\u25cb\u5143\u306e\u30b5\u30fc\u30d0\u3067\u30c0\u30f3\u30d7\u3057\u3001\u5225\u306e\u30b5\u30fc\u30d0\u30fc\u3078\u79fb\u884c\uff08\u30c6\u30b9\u30c8\u74b0\u5883\u3092\u4f5c\u308b\u5834\u5408\u3082\u540c\u3058\uff09<\/p>\n\n\n\n
    \n
  1. \u5143\u306e\u30b5\u30fc\u30d0\u30fc
    mysqldump -u terao -p sns > \/home\/terao\/public_html\/dump\/sns.sql<\/li>\n\n\n\n
  2. \u79fb\u884c\u30b5\u30fc\u30d0\u30fc
    cd \/tmp
    wget\u00a0    http:\/\/papasan.nsm2.net\/dump\/sns.sql<\/a>
    mysql -u root -p sns < sns.sql<\/li>\n<\/ol>\n\n\n\n
    \u5de8\u5927SQL\u306e\u5fa9\u5143<\/h2>\n\n\n\n
      \n
    1. \u00a0mysql\u306b\u30b3\u30f3\u30bd\u30fc\u30eb\u3067\u30ed\u30b0\u30a4\u30f3
      mysql -u terao\u00a0-p<\/li>\n\n\n\n
    2. mysql> USE sankyoSNS
      mysql> SOURCE \/var\/www\/vhosts\/nsm2.net\/sns.sql<\/li>\n<\/ol>\n\n\n\n
      \u307e\u305f\u306f\u3001ssh\u30b3\u30de\u30f3\u30c9\u306e\u307e\u307e\uff08\u3053\u3063\u3061\u306e\u307b\u3046\u304c\u78ba\u5b9f\uff09<\/p>\n\n\n\n
      mysql -u phpmyadmin -p sankyoSNS < \/home\/m-terao\/sns.sql<\/code><\/pre>\n\n\n\n
      mac\u306eMAMP\u306e\u5834\u5408<\/p>\n\n\n\n
        \n
      1. cd \/Applications\/MAMP\/Library\/bin\/mysql80\/bin\/<\/li>\n\n\n\n
      2. .\/mysql -u root -p<\/li>\n\n\n\n
      3. mysql> use sankyoSNS;<\/li>\n\n\n\n
      4. mysql> SOURCE \/Applications\/MAMP\/htdocs\/sns.sql<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"
         \u7279\u5b9a\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u307f\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3059\u308b\u65b9\u6cd5MySQL \u306e\u7279\u5b9a\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30c7\u30fc\u30bf\u3092 dump \u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3059\u308b\u306b\u306f\u3001\u6b21\u306e\u30b3\u30de\u30f3\u30c9\u3067\u884c\u3046\u3002$ mysqldump -u DB\u30e6\u30fc\u30b6\u540d -p DB\u540d & […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[10],"tags":[],"class_list":["post-5824","post","type-post","status-publish","format-standard","hentry","category-mysql"],"acf":[],"_links":{"self":[{"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/posts\/5824","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/comments?post=5824"}],"version-history":[{"count":7,"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/posts\/5824\/revisions"}],"predecessor-version":[{"id":6304,"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/posts\/5824\/revisions\/6304"}],"wp:attachment":[{"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/media?parent=5824"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/categories?post=5824"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/tags?post=5824"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}