涓€銆佹枃浠舵牸寮忛獙璇佷笌淇

瀵煎叆鏂囦欢鐨勭粨鏋勫畬鏁存€х洿鎺ュ奖鍝嶆暟鎹簱鎿嶄綔缁撴灉銆傚缓璁€氳繃浠ヤ笅姝ラ杩涜楠岃瘉锛?/p>

1. 浣跨敤鏂囨湰缂栬緫鍣ㄦ鏌QL鏂囦欢澶撮儴鐨勫瓧绗﹂泦澹版槑
2. 瀵规瘮瀵煎嚭/瀵煎叆鏁版嵁搴撶殑鐗堟湰宸紓锛岄伩鍏嶈娉曞吋瀹规€ч棶棰?/li>
3. 鍦ㄦ祴璇曠幆澧冩墽琛岄儴鍒嗚鍙ラ獙璇佹湁鏁堟€?/li>

鐗规畩瀛楃澶勭悊闇€娉ㄦ剰鏂囦欢淇濆瓨鏃剁殑鎹㈣绗︾被鍨嬶紙CR/LF锛夛紝Windows涓嶭inux绯荤粺宸紓鍙兘瀵艰嚧瑙ｆ瀽閿欒銆?/p>

浜屻€佸瓧绗︾紪鐮佸啿绐佽В鍐?/h2>

缂栫爜涓嶄竴鑷存槸瀵艰嚧涓枃涔辩爜鐨勫父瑙佸師鍥狅紝寤鸿閲囩敤涓夌骇楠岃瘉鏈哄埗锛?/p>

• 鏂囦欢缂栫爜妫€娴嬶細浣跨敤file -i鍛戒护鎴朜otepad++缂栫爜妫€娴嬪姛鑳?/li>
• 鏁版嵁搴撹繛鎺ヨ缃細鎵цSET NAMES 'utf8mb4'璇彞
• 琛ㄧ粨鏋勫畾涔夐獙璇侊細纭繚寤鸿〃璇彞鍖呭惈CHARSET=utf8mb4

褰撻亣鍒癇OM澶村共鎵版椂锛屽彲閫氳繃sed -i '1s/^\xEF\xBB\xBF//'鍛戒护娓呴櫎銆?/p>

涓夈€佸ぇ鏁版嵁閲忓垎鍧楀鐞?/h2>

閽堝瓒呰繃1GB鐨勫ぇ鍨嬫枃浠跺鍏ワ紝鎺ㄨ崘鍒嗗潡澶勭悊绛栫暐锛?/p>

1. 浣跨敤split -l 10000鍛戒护鍒嗗壊SQL鏂囦欢
2. 閫氳繃绠￠亾鍛戒护缁勫悎瀹炵幇娴佸紡澶勭悊锛?code>pv bigfile.sql | mysql -u root dbname
3. 璋冩暣MySQL閰嶇疆鍙傛暟锛?code>max_allowed_packet=256M

鍥涖€佹渶浣冲疄璺靛缓璁?/h2>

寤虹珛鏍囧噯鍖栫殑瀵煎叆娴佺▼鍙噺灏?0%鐨勫父瑙侀敊璇細

鎺ㄨ崘浣跨敤mysqldump --skip-extended-insert鐢熸垚鍙垎鍧楁墽琛岀殑SQL鏂囦欢銆?/p>