如题所述
ä¸è¬çæ°æ®å¤ä»½ç¨ ï¼mysqlè·¯å¾+bin/mysqldump -u ç¨æ·å -p æ°æ®åºå > 导åºçæ件å
æ°æ®è¿åæ¯ï¼å°mysqlå½ä»¤è¡ä¸é¢ï¼ç¨ï¼source æ件å;çæ¹æ³ã
ä½æ¯è¿ç§æ¹æ³å¯¹å¤§æ°æ®éç表è¿è¡æä½å°±éå¸¸æ ¢ãå 为ä»ä¸ä» 导åºäºæ°æ®è¿å¯¼åºäºè¡¨ç»æã
å¨é对大æ°æ®éç表æ¶ï¼æ们å¯ä»¥ç¨infileå outfileæ¥æä½ã
outfile导åºæ°æ®åºæ°æ®çç¨æ³ï¼
ä¸å¾æ们å¯ä»¥çå°6ç¾å¤ä¸æ°æ®35ç§å°±æå®äºï¼
ä¸é¢æ们ççinfileçè¯æ³ï¼
å¨infileå¯¼å ¥æ°æ®çæ¶åï¼æ们è¿å¯ä»¥åä¸äºä¼åãæ们å¯ä»¥ç¨
alter table table_name disable keys å ³éæ®éç´¢å¼ãçæ°æ®å¯¼å ¥ç©ï¼åç¨ï¼
alter table table_name enable keys æ¥å¼å¯æ®éç´¢å¼ãè¿æ ·å°±ä¸ä¼è¾¹å¯¼å ¥æ°æ®ï¼è¾¹æ´çç´¢å¼çäºåæ å¿å½±å导æ°æ®çæçã
å¦æå¯ä»¥ä¿è¯ æ°æ®çæ£ç¡®æ§ï¼æ们å¯ä»¥å°è¡¨çå¯ä¸ç´¢å¼ä¹å ³éï¼ä¹ååå¼å¯,ä¸æ¯æ¯æ¡æ°æ®å°±ç®æ¯å¯ä¸çä»é½è¦å»æ£æµä¸éãå½ä»¤ï¼
set unique_checks=0; #å
³éå¯ä¸æ ¡éª
set unique_checks=1;#å¼å¯å¯ä¸æ ¡éª
å¦ææ¯InnoDBåå¨å¼æï¼æ们è¿å¯ä»¥set auto commit=0;å ³éèªå¨æ交ï¼æ¥æé«æçãInnoDBæ¯æ主é®ç顺åºä¿åçï¼æ们å°å ¶ä¸»é®é¡ºåºæåä¹å¯ä»¥æé«æçã
ä¸é¢æ们对myisamå¼æç表å个æµè¯ï¼æ们å ä¸å ³ç´¢å¼ï¼å¯¼å ¥æ°æ®(ç¨äºè¿4åé)ï¼
ç¶åæ们å æç´¢å¼å ³éè¯è¯(åªç¨äºä¸åéå¤ä¸ç¹ï¼å¿«äºä¸å°åï¼æ¸æ¸å¤§ï¼)ï¼