Warning: include(/home/blog66rr/public_html/wp-content/plugins/hyper-cache/cache.php): failed to open stream: No such file or directory in /home/blog66rr/public_html/wp-content/advanced-cache.php on line 24
Warning: include(/home/blog66rr/public_html/wp-content/plugins/hyper-cache/cache.php): failed to open stream: No such file or directory in /home/blog66rr/public_html/wp-content/advanced-cache.php on line 24
Warning: include(): Failed opening '/home/blog66rr/public_html/wp-content/plugins/hyper-cache/cache.php' for inclusion (include_path='.:/opt/cpanel/ea-php70/root/usr/share/pear') in /home/blog66rr/public_html/wp-content/advanced-cache.php on line 24
Warning: Cannot modify header information - headers already sent by (output started at /home/blog66rr/public_html/wp-content/advanced-cache.php:24) in /home/blog66rr/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1723
Warning: Cannot modify header information - headers already sent by (output started at /home/blog66rr/public_html/wp-content/advanced-cache.php:24) in /home/blog66rr/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1723
Warning: Cannot modify header information - headers already sent by (output started at /home/blog66rr/public_html/wp-content/advanced-cache.php:24) in /home/blog66rr/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1723
Warning: Cannot modify header information - headers already sent by (output started at /home/blog66rr/public_html/wp-content/advanced-cache.php:24) in /home/blog66rr/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1723
Warning: Cannot modify header information - headers already sent by (output started at /home/blog66rr/public_html/wp-content/advanced-cache.php:24) in /home/blog66rr/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1723
Warning: Cannot modify header information - headers already sent by (output started at /home/blog66rr/public_html/wp-content/advanced-cache.php:24) in /home/blog66rr/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1723
Warning: Cannot modify header information - headers already sent by (output started at /home/blog66rr/public_html/wp-content/advanced-cache.php:24) in /home/blog66rr/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1723
Warning: Cannot modify header information - headers already sent by (output started at /home/blog66rr/public_html/wp-content/advanced-cache.php:24) in /home/blog66rr/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1723
{"id":60,"date":"2011-08-23T08:12:00","date_gmt":"2011-08-23T16:12:00","guid":{"rendered":"http:\/\/blog.unethost.com\/?p=60"},"modified":"2014-04-16T16:34:36","modified_gmt":"2014-04-16T08:34:36","slug":"move_mysql_database_by_command","status":"publish","type":"post","link":"https:\/\/blog.unethost.com\/move_mysql_database_by_command\/","title":{"rendered":"\u900f\u904ecommand\u4f86\u642cmysql\u8cc7\u6599\u5eab"},"content":{"rendered":"\u7368\u7acb\u4e3b\u6a5f\u7684\u5ba2\u6236\uff0c\u5f9e\u5225\u5bb6\u642c\u904e\u4f86\uff0cmysql\u7684\u8cc7\u6599\u5eab\u7e3d\u662f\u642c\u4e0d\u597d\u3002\u900f\u904ephpmyadmin\u4e5f\u662f\u641e\u4e0d\u5b9a\u3002\u5176\u5be6phpmyadmin\u6703\u6709error\u4e5f\u662f\u5f88\u6b63\u5e38\u7684\u4e8b\u3002phpmyadmin\u662f\u8dd1\u5728http protocol\u4e4b\u4e0a\u7684\u3002http \u7684post\u5982\u679c\u6709\u6642\u9593\u9650\u5236\u6216\u662fphp\u7684\u57f7\u884c\u6642\u9593\u6709\u9650\u5236\uff0c\u5c31\u5f88\u5bb9\u6613timout\u3002<\/p>\n
\u6c92\u6709\u8fa6\u6cd5\uff0c\u53ea\u597d\u76f4\u63a5\u4e0bcommand\u4f86\u642c\u3002<\/p>\n
<<\u532f\u51fa>>
\nmysqldump -u “your_username” -p –lock-tables –databases DB1 [DB2 DB3…] >\u00a0your_database_dump.sql<\/p>\n
<<\u532f\u5165>>
\nmysql -u “your username” -p “your_database” < database_dump.sql<\/p>\n
\u5982\u679c\u532f\u51fa\u7684\u6642\u5019\uff0c\u6709using –all-databases \u9078\u9805\uff0c\u53ef\u4ee5\u4f7f\u7528\uff1a
\nmysql -u “your_username” -p < your_database_dump.sql \u00a0 \u4f86\u532f\u5165\uff0c\u6bd4\u8f03\u7c21\u55ae\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u7368\u7acb\u4e3b\u6a5f\u7684\u5ba2\u6236\uff0c\u5f9e\u5225\u5bb6\u642c\u904e\u4f86\uff0cmysql\u7684\u8cc7\u6599\u5eab\u7e3d\u662f\u642c\u4e0d\u597d\u3002\u900f\u904ephpmyadmin\u4e5f\u662f\u641e\u4e0d\u5b9a\u3002\u5176\u5be6phpmy … \u95b1\u8b80\u5168\u6587 \u900f\u904ecommand\u4f86\u642cmysql\u8cc7\u6599\u5eab<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false},"categories":[4],"tags":[22],"_links":{"self":[{"href":"https:\/\/blog.unethost.com\/wp-json\/wp\/v2\/posts\/60"}],"collection":[{"href":"https:\/\/blog.unethost.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.unethost.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.unethost.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.unethost.com\/wp-json\/wp\/v2\/comments?post=60"}],"version-history":[{"count":4,"href":"https:\/\/blog.unethost.com\/wp-json\/wp\/v2\/posts\/60\/revisions"}],"predecessor-version":[{"id":145,"href":"https:\/\/blog.unethost.com\/wp-json\/wp\/v2\/posts\/60\/revisions\/145"}],"wp:attachment":[{"href":"https:\/\/blog.unethost.com\/wp-json\/wp\/v2\/media?parent=60"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.unethost.com\/wp-json\/wp\/v2\/categories?post=60"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.unethost.com\/wp-json\/wp\/v2\/tags?post=60"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}