{"id":3407,"date":"2016-06-03T00:00:24","date_gmt":"2016-06-02T16:00:24","guid":{"rendered":"https:\/\/sofree.cc\/?p=3407"},"modified":"2016-06-05T20:56:29","modified_gmt":"2016-06-05T12:56:29","slug":"bigdump-sql-import","status":"publish","type":"post","link":"https:\/\/sofree.cc\/bigdump-sql-import\/","title":{"rendered":"BigDump \u6559\u4f60\u4e0d\u4f7f\u7528phpMyadmin\u532f\u5165\u5927\u65bc2MB\u7684MySQL\u8cc7\u6599\u5eab"},"content":{"rendered":"<p>\u7db2\u7ad9\u5728\u642c\u5bb6\u7684\u6642\u5019\uff0c\u5e38\u6703\u9047\u5230\u8cc7\u6599\u5eab\u592a\u5927\u7121\u6cd5\u532f\u5165\uff0c\u770b\u8457\u7db2\u8def\u6559\u5b78\u8aaa\u6539php.ini\u53ef\u4ee5\u89e3\u6c7a\uff0c\u4f46\u662f\u5be6\u969b\u64cd\u4f5c\u767c\u73fe\u5b8c\u5168\u7121\u6cd5\u3002\u9019\u6a23\u7684\u72c0\u6cc1\u4e0b\uff0c\u53ef\u4ee5\u4f7f\u7528\u7b2c\u4e09\u65b9\u5de5\u5177\u300c<em>BigDump<\/em>\u300d\u5354\u52a9\u60a8\u5c07\u8d85\u904e2MB\u4ee5\u4e0a\u7684SQL\u532f\u5165\u5230\u60a8\u7684\u8cc7\u6599\uff0c\u89e3\u6c7a\u8cc7\u6599\u5eab\u532f\u51fa\u6a94\u592a\u5927\u7121\u6cd5\u532f\u5165MySQL\u7684\u72c0\u6cc1\u3002phpMyadmin\u96d6\u7136\u597d\u7528\uff0c\u53ef\u662f\u4e00\u822c\u4e3b\u6a5f\u90fd\u6709\u9396\u5b9a\u5176\u4e0a\u9650\uff0c\u5982\u679c\u7121\u6cd5\u89e3\u6c7a\u6b64\u9650\u5236\uff0c\u5c31\u9760BigDump\u3002<\/p>\n<p><strong>BigDump<\/strong>\u9019\u5de5\u5177\u5f88\u4e45\u4e86\uff0c\u8a31\u591a\u7db2\u8def\u524d\u8f29\uff0c\u4ee5\u524d\u4f7f\u7528\u514d\u8cbb\u7a7a\u9593\/\u4ed8\u8cbb\u7a7a\u9593\uff0c\u5728phpMyadmin\u532f\u5165\u4ecb\u9762\u4e2d\u6bcf\u6b21\u90fd\u9047\u5230\u9396\u5b9a\u70ba2MB\u7684\u6642\u5019\uff0c\u4f7f\u7528\u9019\u500b\u5de5\u5177\u53ef\u4ee5\u8d85\u5feb\u901f\u532f\u5165\uff0c\u4e0d\u9700\u8981\u53bb\u7406\u89e3POST VALUE\u8981\u6539\u591a\u5c11\u3001php.ini\u3001.htaccess\u5230\u5e95\u8981\u600e\u9ebc\u4e9b\u6539\uff0c\u624d\u80fd\u89e3\u6c7a\u9019\u6a23\u7684\u72c0\u6cc1\u3002\u53ef\u4ee5\u89e3\u6c7a\u8a31\u591a\u56f0\u96e3\u8207\u9ebb\u7169\u4e8b\uff0c\u8b93\u8cc7\u6599\u5eab\u53ef\u4ee5\u9806\u5229\u532f\u5165\u7cfb\u7d71\u4e2d\u3002<\/p>\n<p><!--more--><\/p>\n<p>\u4f7f\u7528<a href=\"https:\/\/sofree.cc\/bigdump-sql-import\/\">BigDump<\/a>\u4e3b\u8981\u662f\u91dd\u5c0d\u60a8\u7121\u6240\u6709\u6b0a\u53ef\u4ee5\u4fee\u6539\u4e3b\u6a5f\u7684\u7cfb\u7d71\u8cc7\u6e90\u9650\u5236\uff0c\u5982\u679c\u6709\u4e3b\u6a5f\u6700\u9ad8\u6b0a\u9650\uff0c\u53ef\u4ee5\u76f4\u63a5\u7528SSH\u6307\u4ee4\u5c07SQL\u6a94\u6848\u532f\u5165\u3002\u5982\u679c\u6c92\u6709\u6700\u9ad8\u6b0a\u9650\uff0c\u4f46\u80fd\u6709\u6b0a\u9650\u4fee\u6539php.ini\u7684\u8a71\uff0c\u90a3\u60a8\u7684\u8a2d\u5b9a\u503c\u4e0a\u53ef\u4ee5\u5617\u8a66\u4fee\u6539\u300cupload_max_filesize\u300d\u3001\u300cpost_max_size\u300d\u3001\u300c<a href=\"https:\/\/sofree.cc\/wordpress-memory-limit\/\" target=\"_blank\">memory_limit<\/a>\u300d\u53ef\u4ee5\u89e3\u6c7a\u60a8\u7684\u4e0a\u50b3\u9650\u5236\u554f\u984c\uff0c\u56e0\u70ba\u9650\u5236\u5927\u591a\u767c\u751f\u5728\u6a94\u6848\u5bb9\u91cf\u4e0a\u9650\u3001\u8a18\u61b6\u9ad4\u8cc7\u6e90\u3001POST\u5927\u5c0f\u9650\u5236\u3002<\/p>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border: 0px;\" title=\"BigDump \u6559\u4f60\u4e0d\u4f7f\u7528phpMyadmin\u4e5f\u53ef\u532f\u5165\u5927\u65bc2MB\u7684MySQL\u8cc7\u6599\u5eab\" src=\"https:\/\/i0.wp.com\/sofree.cc\/wp-content\/uploads\/phpMyadmin2MBMySQLBigDump_D463\/bigdump_sql_cover.jpg?resize=700%2C367&#038;quality=99&#038;ssl=1\" alt=\"BigDump \u6559\u4f60\u4e0d\u4f7f\u7528phpMyadmin\u4e5f\u53ef\u532f\u5165\u5927\u65bc2MB\u7684MySQL\u8cc7\u6599\u5eab\" width=\"700\" height=\"367\" border=\"0\" \/><\/p>\n<p>BigDump\u6b64\u5de5\u5177\u50c5\u70ba\u4e00\u96bb\u7c21\u6613\u7684PHP\uff0c\u4f46\u537b\u975e\u5e38\u5be6\u7528\uff0c\u591a\u5e74\u4f86\u5c79\u7acb\u4e0d\u6416\u3002\u53ea\u8981\u628a\u8cc7\u6599\u5eab\u8207BigDump\u7a0b\u5f0f\u4e0a\u50b3\u5230\u540c\u4e00\u76ee\u9304\uff0c\u7136\u5f8c<em>BigDump<\/em>\u5167\u7684\u8a2d\u5b9a\u503c\u8a2d\u5b9a\u8cc7\u6599\u5eab\u7684\u5e33\u865f\u3001\u5bc6\u78bc\u3001\u9023\u7dda\u4f4d\u5740\u3001\u8981\u532f\u5165\u7684SQL\u6a94\u6848\u540d\u7a31\u3001\u7de8\u78bc\u8a2d\u5b9a\uff0c\u63a5\u8457\u958b\u555f\u7db2\u9801\u8b80\u53d6BigDump\uff0c\u5c31\u80fd\u57f7\u884c\u8cc7\u6599\u5eab\u532f\u5165\u7684\u52d5\u4f5c\uff0c\u7576\u8cc7\u6599\u5eab\u532f\u5165\u5b8c\u7562\u5f8c\u7db2\u9801\u6703\u986f\u793a\u5b8c\u6210\u7684\u76f8\u95dc\u8cc7\u8a0a\uff0c\u90a3\u60a8\u53ea\u8981\u628a\u532f\u5165\u7a0b\u5f0f\u548c\u8cc7\u6599\u5eab\u522a\u9664\uff0c\u6536\u5de5\u3002<\/p>\n<blockquote>\n<ul>\n<li>\u7a0b\u5f0f\u540d\u7a31\uff1aBigDump<\/li>\n<li>\u5b98\u65b9\u7db2\u7ad9\uff1a<a href=\"http:\/\/www.ozerov.de\/bigdump\/\" target=\"_blank\" rel=\"nofollow noopener\">http:\/\/www.ozerov.de\/bigdump\/<\/a><\/li>\n<li>\u7a0b\u5f0f\u4e0b\u8f09\uff1a<a href=\"http:\/\/www.ozerov.de\/bigdump.zip\" target=\"_blank\" rel=\"nofollow noopener\">\u6309\u6b64\u4e0b\u8f09<\/a><\/li>\n<\/ul>\n<\/blockquote>\n<p><span style=\"color: #008000;\"><strong>\u7b2c1\u6b65\u00a0<\/strong><\/span> \u5148\u628aBigDump\u4e0b\u8f09\u5f8c\uff0c\u4f7f\u7528\u7528<a href=\"https:\/\/sofree.cc\/software-notepad-edit\/\" target=\"_blank\">Notepad++<\/a>\u3001<a href=\"https:\/\/sofree.cc\/notepad2\/\" target=\"_blank\">NotePad2<\/a>\u3001Sublime\u4e4b\u985e\u7684\u5beb\u7a0b\u5f0f\u8edf\u9ad4\u958b\u555f\u300cbigdump.php\u300d\u3002\u8acb\u4f9d\u5e8f\u5c07\u6307\u793a\u7684\u5730\u65b9\u8f38\u5165\u597d\u8cc7\u6599\uff0c\u7136\u5f8c\u5b58\u6a94\u3002<\/p>\n<ul>\n<li>db_server\uff1a\u8cc7\u6599\u5eab\u4e3b\u6a5f\u4f4d\u7f6e\uff0c\u9810\u8a2d\u90fd\u662flocalhost\u3002<\/li>\n<li>db_name\uff1a\u8cc7\u6599\u5eab\u540d\u7a31<\/li>\n<li>db_username\uff1a\u8cc7\u6599\u5eab\u4f7f\u7528\u8005\u540d\u7a31<\/li>\n<li>db_password\uff1a\u8cc7\u6599\u5eab\u4f7f\u7528\u8005\u5bc6\u78bc<\/li>\n<li>db_connection_charset\uff1a\u8cc7\u6599\u5eab\u7de8\u78bc\uff0c\u901a\u5e38\u6703\u8996utf8<\/li>\n<li>filename\uff1a\u8981\u532f\u5165\u7684\u8cc7\u6599\u5eab\u6a94\u6848\u540d\u7a31\u3002<\/li>\n<\/ul>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border: 0px;\" title=\"BigDump \u6559\u4f60\u4e0d\u4f7f\u7528phpMyadmin\u4e5f\u53ef\u532f\u5165\u5927\u65bc2MB\u7684MySQL\u8cc7\u6599\u5eab\" src=\"https:\/\/i0.wp.com\/sofree.cc\/wp-content\/uploads\/phpMyadmin2MBMySQLBigDump_D463\/bigdump_3.png?resize=700%2C399&#038;quality=99&#038;ssl=1\" alt=\"BigDump \u6559\u4f60\u4e0d\u4f7f\u7528phpMyadmin\u4e5f\u53ef\u532f\u5165\u5927\u65bc2MB\u7684MySQL\u8cc7\u6599\u5eab\" width=\"700\" height=\"399\" border=\"0\" \/><\/p>\n<p><span style=\"color: #008000;\"><strong>\u7b2c2\u6b65<\/strong><\/span>\u00a0 \u4e0a\u9762\u90a3\u96bb\u300cbigdump.php\u300d\u6a94\u6848\u8acb\u4e0a\u50b3\u5230\u7db2\u7ad9\u6839\u76ee\u9304\u3002\u53e6\u5916\u4e5f\u5c07\u60a8\u8981\u532f\u5165\u7684\u8cc7\u6599\u5eab\u4e5f\u4e0a\u50b3\u5230\u6839\u76ee\u9304\uff0c\u5169\u8005\u5fc5\u9808\u5728\u540c\u4e00\u500b\u76ee\u9304\u4e0b\u3002\u53e6\u5916\u8981\u532f\u5165\u7684\u8cc7\u6599\u5eab\u7684\u540d\u7a31\uff0c\u5fc5\u9808\u8207\u7b2c\u4e00\u6b65\u9a5f\u7684filename\u76f8\u540c\u3002<\/p>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border: 0px;\" title=\"BigDump \u6559\u4f60\u4e0d\u4f7f\u7528phpMyadmin\u4e5f\u53ef\u532f\u5165\u5927\u65bc2MB\u7684MySQL\u8cc7\u6599\u5eab\" src=\"https:\/\/i0.wp.com\/sofree.cc\/wp-content\/uploads\/phpMyadmin2MBMySQLBigDump_D463\/bigdump_0.png?resize=700%2C473&#038;quality=99&#038;ssl=1\" alt=\"BigDump \u6559\u4f60\u4e0d\u4f7f\u7528phpMyadmin\u4e5f\u53ef\u532f\u5165\u5927\u65bc2MB\u7684MySQL\u8cc7\u6599\u5eab\" width=\"700\" height=\"473\" border=\"0\" \/><\/p>\n<p><span style=\"color: #008000;\"><strong>\u7b2c3\u6b65<\/strong><\/span>\u00a0 \u63a5\u8457\uff0c\u8acb\u8b80\u53d6\u7db2\u7ad9\u9996\u9801\u7db2\u5740\uff0c\u7db2\u5740\u5f8c\u65b9\u52a0\u4e0a\u300c<span style=\"color: #0000ff;\">\/bigdump.php<\/span>\u300d\uff0c\u5c31\u53ef\u4ee5\u9032\u5165\u4ee5\u4e0b\u756b\u9762\uff0c\u9ede\u9078\u300cStart Import\u300d\u958b\u59cb\u532f\u5165\uff0c\u8acb\u8010\u5fc3\u7b49\u5019\u3002<\/p>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border: 0px;\" title=\"BigDump \u6559\u4f60\u4e0d\u4f7f\u7528phpMyadmin\u4e5f\u53ef\u532f\u5165\u5927\u65bc2MB\u7684MySQL\u8cc7\u6599\u5eab\" src=\"https:\/\/i0.wp.com\/sofree.cc\/wp-content\/uploads\/phpMyadmin2MBMySQLBigDump_D463\/bigdump_1.png?resize=700%2C335&#038;quality=99&#038;ssl=1\" alt=\"BigDump \u6559\u4f60\u4e0d\u4f7f\u7528phpMyadmin\u4e5f\u53ef\u532f\u5165\u5927\u65bc2MB\u7684MySQL\u8cc7\u6599\u5eab\" width=\"700\" height=\"335\" border=\"0\" \/><\/p>\n<p><span style=\"color: #008000;\"><strong>\u7b2c4\u6b65\u00a0<\/strong><\/span> \u532f\u5165\u5b8c\u7562\u5f8c\u6703\u6536\u5230\u901a\u77e5\uff0c\u4e0b\u65b9\u6703\u986f\u793a\u532f\u5165\u5b8c\u6210\uff0c\u9019\u6642\u8a18\u5f97\u5230FTP\u5c07\u525b\u525b\u4e0a\u50b3\u7684bigdump.php\u548c\u4f60\u7684SQL\u6a94\u6848\u522a\u9664\uff0c\u5c31\u53ef\u4ee5\u56c9\uff01<\/p>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border: 0px;\" title=\"BigDump \u6559\u4f60\u4e0d\u4f7f\u7528phpMyadmin\u4e5f\u53ef\u532f\u5165\u5927\u65bc2MB\u7684MySQL\u8cc7\u6599\u5eab\" src=\"https:\/\/i0.wp.com\/sofree.cc\/wp-content\/uploads\/phpMyadmin2MBMySQLBigDump_D463\/bigdump_2.png?resize=700%2C454&#038;quality=99&#038;ssl=1\" alt=\"BigDump \u6559\u4f60\u4e0d\u4f7f\u7528phpMyadmin\u4e5f\u53ef\u532f\u5165\u5927\u65bc2MB\u7684MySQL\u8cc7\u6599\u5eab\" width=\"700\" height=\"454\" border=\"0\" \/><\/p>\n<p>\u96d6\u7136\u5927\u8cc7\u6599\u5eab\u5e38\u6703\u767c\u751f\u5728<a href=\"https:\/\/sofree.cc\/discuz-x1\/\" target=\"_blank\">Discuz<\/a>\u3001<a href=\"https:\/\/sofree.cc\/install-drupal\/\" target=\"_blank\">Drupal<\/a>\u9019\u985e\u6bd4\u8f03\u8907\u96dc\u7684\u5927\u67b6\u69cb\u7cfb\u7d71\u7a0b\u5f0f\u3002\u6709\u6642\u5019<a href=\"https:\/\/sofree.cc\/wordpress-box-tip-4\/\" target=\"_blank\">WordPress<\/a>\u5982\u679c\u4f60\u6587\u7ae0\u5f88\u591a\uff0c\u5728\u642c\u5bb6\u3001\u63db\u4e3b\u6a5f\u5546\u7684\u72c0\u6cc1\u4e0b\uff0c\u4e5f\u6703\u9047\u5230WordPress\u8cc7\u6599\u5eab\u7121\u6cd5\u532f\u5165\u7684\u72c0\u6cc1\uff0c\u5229\u7528\u6b64\u65b9\u6cd5\u5c31\u7b97\u662f<a href=\"https:\/\/sofree.cc\/about-free-web-hosting\/\" target=\"_blank\">\u514d\u8cbb\u4e3b\u6a5f<\/a>\uff0c\u4e5f\u80fd\u8f15\u9b06\u5c07\u8cc7\u6599\u5eab\u532f\u5165\u3002\u4e0d\u904e\u5982\u679c\u514d\u8cbb\u4e3b\u6a5f\u53c8\u81ea\u5df1\u984d\u5916\u4e82\u9396\u5b9a\u6771\u897f\u6216\u8005\u662f\u4e82\u52a0\u5165\u5ee3\u544a\u9020\u6210\u7a0b\u5f0f\u7121\u6cd5\u57f7\u884c\uff0c\u90a3\u4f60\u5c31\u53ea\u80fd\u6478\u6478\u9f3b\u5b50\uff0c\u63db\u500b\u597d\u4e00\u9ede\u7684\u865b\u64ec\u4e3b\u6a5f\u56c9\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u7db2\u7ad9\u5728\u642c\u5bb6\u7684\u6642\u5019\uff0c\u5e38\u6703\u9047\u5230\u8cc7\u6599\u5eab\u592a\u5927\u7121\u6cd5\u532f\u5165\uff0c\u770b\u8457\u7db2\u8def\u6559\u5b78\u8aaa\u6539php.ini\u53ef\u4ee5\u89e3\u6c7a\uff0c\u4f46\u662f\u5be6\u969b\u64cd\u4f5c\u767c\u73fe\u5b8c\u5168\u7121\u6cd5 [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"footnotes":""},"categories":[282],"tags":[3686,526,524,525],"class_list":["post-3407","post","type-post","status-publish","format-standard","hentry","category-build-website","tag-bigdump","tag-mysql","tag-phpmyadmin","tag-525"],"blocksy_meta":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/sofree.cc\/wp-json\/wp\/v2\/posts\/3407","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sofree.cc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sofree.cc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sofree.cc\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sofree.cc\/wp-json\/wp\/v2\/comments?post=3407"}],"version-history":[{"count":0,"href":"https:\/\/sofree.cc\/wp-json\/wp\/v2\/posts\/3407\/revisions"}],"wp:attachment":[{"href":"https:\/\/sofree.cc\/wp-json\/wp\/v2\/media?parent=3407"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sofree.cc\/wp-json\/wp\/v2\/categories?post=3407"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sofree.cc\/wp-json\/wp\/v2\/tags?post=3407"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}