{"id":105,"date":"2019-08-31T22:37:25","date_gmt":"2019-08-31T14:37:25","guid":{"rendered":"http:\/\/blog.coolcoding.cn\/?p=105"},"modified":"2020-08-24T15:25:54","modified_gmt":"2020-08-24T07:25:54","slug":"mysql%e6%95%b0%e6%8d%ae%e7%9a%84%e5%af%bc%e5%85%a5%e5%af%bc%e5%87%ba","status":"publish","type":"post","link":"https:\/\/blog.coolcoding.cn\/?p=105","title":{"rendered":"mysql\u6570\u636e\u7684\u5bfc\u5165\u5bfc\u51fa"},"content":{"rendered":"\n

1 \u5bfc\u51fa\u6240\u6709\u5e93
\u7cfb\u7edf\u547d\u4ee4\u884c
mysqldump -uusername -ppassword –all-databases > all.sql<\/p>\n\n\n\n

\u5982\u679c\u5bc6\u7801\u4e2d\u6709\u7279\u6b8a\u5b57\u7b26\uff0c\u5219\u53ef\u4ee5\uff1a
(1)\u5728\u7279\u6b8a\u5b57\u7b26\u524d\u6dfb\u52a0\u53cd\u659c\u6760\uff0c\u5982 -p\\!\\&hehe
(2)\u9996\u5c3e\u6dfb\u52a0\u5355\u5f15\u53f7\uff0c\u5982 -p’!!@@&&’<\/p>\n\n\n\n

2 \u5bfc\u5165\u6240\u6709\u5e93
\n mysql\u547d\u4ee4\u884c
\n mysql>source all.sql;<\/p>\n\n\n\n

3 \u5bfc\u51fa\u67d0\u4e9b\u5e93
\u7cfb\u7edf\u547d\u4ee4\u884c
mysqldump -uusername -ppassword –databases db1 db2 > db1db2.sql
mysqldump -h127.0.0.1 -uroot -p123456 uwlog > my.sql<\/p>\n\n\n\n

4 \u5bfc\u5165\u67d0\u4e9b\u5e93
\n mysql\u547d\u4ee4\u884c
\n mysql>source db1db2.sql;<\/p>\n\n\n\n

5 \u5bfc\u5165\u67d0\u4e2a\u5e93
\n \u7cfb\u7edf\u547d\u4ee4\u884c
\n mysql -uusername -ppassword db1 < db1.sql;\n \u6216mysql\u547d\u4ee4\u884c\n mysql>source db1.sql;<\/p>\n\n\n\n

6 \u5bfc\u51fa\u67d0\u4e9b\u6570\u636e\u8868
\n \u7cfb\u7edf\u547d\u4ee4\u884c
\n mysqldump -uusername -ppassword db1 table1 table2 > tb1tb2.sql<\/p>\n\n\n\n

7 \u5bfc\u5165\u67d0\u4e9b\u6570\u636e\u8868
\n \u7cfb\u7edf\u547d\u4ee4\u884c
\n mysql -uusername -ppassword db1 < tb1tb2.sql\n \u6216mysql\u547d\u4ee4\u884c\n mysql>
\n user db1;
\n source tb1tb2.sql;<\/p>\n\n\n\n

8 mysqldump\u5b57\u7b26\u96c6\u8bbe\u7f6e
\n mysqldump -uusername -ppassword –default-character-set=gb2312 db1 table1 > tb1.sql<\/p>\n","protected":false},"excerpt":{"rendered":"

1 \u5bfc\u51fa\u6240\u6709\u5e93 \u7cfb\u7edf\u547d\u4ee4\u884c mysqldump -uusername -ppassword –al […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.coolcoding.cn\/index.php?rest_route=\/wp\/v2\/posts\/105"}],"collection":[{"href":"https:\/\/blog.coolcoding.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.coolcoding.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.coolcoding.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.coolcoding.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=105"}],"version-history":[{"count":5,"href":"https:\/\/blog.coolcoding.cn\/index.php?rest_route=\/wp\/v2\/posts\/105\/revisions"}],"predecessor-version":[{"id":2238,"href":"https:\/\/blog.coolcoding.cn\/index.php?rest_route=\/wp\/v2\/posts\/105\/revisions\/2238"}],"wp:attachment":[{"href":"https:\/\/blog.coolcoding.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=105"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.coolcoding.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=105"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.coolcoding.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=105"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}