å ä¸ºè¢«ç ´åçå°æ¹åªå¨ç´¢å¼çé¨åï¼æ以å½ä½¿ç¨innodb_force_recovery = 1è¿è¡InnoDBæ¶ï¼æä½å¦ä¸ï¼
æ§è¡checkï¼repair table é½æ æ
alter table email_status engine =myisam; #ä¹æ¥éäºï¼å 为模å¼æ¯innodb_force_recovery =1ã
ERROR 1025 (HY000): Error on rename of '...' to '....' (errno: -1)
建ç«ä¸å¼ 表ï¼create table email_status_bak #åå表ç»æä¸æ ·ï¼åªæ¯æINNODBæ¹æäºMYISAMãææ°æ®å¯¼è¿å»insert into email_status_bak select * from email_status;
å é¤æå表ï¼
drop table email_status;
注éæinnodb_force_recovery ä¹åï¼éå¯ã
éå½åï¼
rename table edm_email_status_bak to email_status;
æå该ååå¨å¼æ
alter table edm_email_status engine = innodb
æ»ç»ï¼
è¿éçä¸ä¸ªéè¦ç¥è¯ç¹å°±æ¯ 对 innodb_force_recovery åæ°çç解äºï¼è¦æ¯éå°æ°æ®æåçè³æ¯å
¶ä»çæåãå¯è½ä¸é¢çæ¹æ³ä¸è¡äºï¼éè¦å°è¯å¦ä¸ä¸ªæ¹æ³ï¼insert into tb select * from ta limit Xï¼çè³æ¯dumpåºå»ï¼åloadåæ¥ã
温馨提示:答案为网友推荐,仅供参考