{"id":861,"date":"2016-06-15T09:02:55","date_gmt":"2016-06-15T01:02:55","guid":{"rendered":"http:\/\/cn.hostease.com\/xueyuan\/?p=861"},"modified":"2016-06-15T09:17:07","modified_gmt":"2016-06-15T01:17:07","slug":"mysql%e6%95%b0%e6%8d%ae%e5%ba%93%e6%94%b9%e5%90%8d","status":"publish","type":"post","link":"https:\/\/cn.hostease.com\/xueyuan\/jishu\/shujuku\/mysql%e6%95%b0%e6%8d%ae%e5%ba%93%e6%94%b9%e5%90%8d\/","title":{"rendered":"MySQL\u6570\u636e\u5e93\u6539\u540d"},"content":{"rendered":"
\n

mysql\u6570\u636e\u5e93\u6539\u540d<\/strong><\/p>\n

\u67d0\u9879\u76ee\u4e2d\u6709\u9700\u6c42\u8981\u5c06\u6570\u636e\u5e93\u6539\u4e2a\u540d\u5b57\uff0c\u4eceMySQL\u7684\u53c2\u8003\u624b\u518c\u4e2d\u53d1\u73b0\u6709rename database\u7684SQL\u547d\u4ee4\uff0c\u5174\u51b2\u51b2\u7684\u6267\u884c\u4e86<\/p>\n

mysql> rename database db1 to db2;
\nERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use n
\nr ‘database db1 to db2’ at line 1<\/p>\n

\u67e5\u4e86\u4e00\u4e0b\uff0c\u53d1\u73b0\u8fd9\u6761\u547d\u4ee4\u5728MySQL 5.1.7\u7684\u65f6\u5019\u88ab\u6dfb\u52a0\u8fdb\u6765\uff0c5.1.23\u7684\u65f6\u5019\u53c8\u88ab\u53bb\u6389\u4e86\uff0c\u67e5\u4e86\u4e00\u4e0b\u7248\u672c\uff1a<\/p>\n

mysql> select @@version;
\n| @@version |
\n+———–+
\n| 5.5.23 |
\n+———–+<\/p>\n

\u518d\u60f3\u5176\u4ed6\u529e\u6cd5\uff0c\u67e5\u4e86\u4e00\u4e9b\u8d44\u6599\u4ee5\u540e\u603b\u7ed3\u5982\u4e0b\uff1a<\/p>\n

1\u3001MYISAM\u5f15\u64ce\u628a\u5e93\u540d\u5b57\u5bf9\u5e94\u7684\u6587\u4ef6\u5939\u540d\u6539\u4e86<\/p>\n

1.1\u3001\u5173\u95edmysqld<\/p>\n

1.2\u3001\u628adata\u76ee\u5f55\u4e2d\u7684db_name\u76ee\u5f55\u91cd\u547d\u540d\u4e3anew_db_name<\/p>\n

1.3\u3001\u6253\u5f00mysqld<\/p>\n

2\u3001INNODB\u5f15\u64ce\u5206\u4e3a\u4e0b\u9762\u51e0\u4e2a\u6b65\u9aa4\uff1a<\/p>\n

2.1 \u6309\u65b0\u540d\u5b57\u5efa\u7acb\u4e00\u4e2a\u6570\u636e\u5e93<\/p>\n

2.2 \u5220\u9664\u539f\u6709\u5e93\u4e2d\u6240\u6709\u8868\u4e0a\u7684\u89e6\u53d1\u5668<\/p>\n

2.3 \u4f7f\u7528rename table\u547d\u4ee4\u5c06\u8868\u4ece\u539f\u6570\u636e\u5e93\u590d\u5236\u5230\u65b0\u6570\u636e\u5e93<\/p>\n

2.4 \u5728\u65b0\u6570\u636e\u5e93\u4e0a\u91cd\u65b0\u521b\u5efa2.2\u4e2d\u88ab\u5220\u9664\u7684\u89e6\u53d1\u5668<\/p>\n

2.5 \u5728\u65b0\u6570\u636e\u5e93\u4e0a\u91cd\u65b0\u521b\u5efa\u5b58\u50a8\u8fc7\u7a0b\u3001\u81ea\u5b9a\u4e49\u51fd\u6570\u3001Events\u7b49<\/p>\n

RENAME TABLE\u547d\u4ee4\u8bed\u6cd5\uff1a<\/p>\n

RENAME TABLE db_name.table1 TO new_db_name.table1,
\ndb_name.table2 TO new_db_name.table2;<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

mysql\u6570\u636e\u5e93\u6539\u540d \u67d0\u9879\u76ee\u4e2d\u6709\u9700\u6c42\u8981\u5c06\u6570\u636e\u5e93\u6539\u4e2a\u540d\u5b57\uff0c\u4eceMySQL\u7684\u53c2\u8003\u624b\u518c\u4e2d\u53d1\u73b0\u6709rename datab … \u9605\u8bfb\u66f4\u591a<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[10],"tags":[],"class_list":["post-861","post","type-post","status-publish","format-standard","hentry","category-shujuku"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/861","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/comments?post=861"}],"version-history":[{"count":2,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/861\/revisions"}],"predecessor-version":[{"id":863,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/861\/revisions\/863"}],"wp:attachment":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/media?parent=861"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/categories?post=861"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/tags?post=861"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}