资源描述：
《mysql数据表损坏的原因分析和修复方法》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。
1、MYSQL数据表损坏的原因分析和修复方法AnalysisofthecauseofthebreakdownThefollowingreasonsareacommoncauseforthedestructionofmysqltables:1,theserversuddenlylosespowerandcausesthedatafiletobedamaged・Forcedshutdown,didn'tturnoffmysqlservicefirst・Themysqldprocessiskilledwhenwriting
2、atable・Usingmyisamchk,mysqldisalsointheoperationtable・Diskfailure・Theservercrashed・Thebugsofmysqlitself・31ian(www・31ian.com)SymptomsoftabledamageAtypicalsymptomofadamagedwatchisasfollows:Whenselectingdatafromthetable,yougetthefollowingerror:Incorrectkeyfilefo
3、rtable:'Trytorepairit'Thequerycannotfindaroworreturnincompletedatainthetable.Error:Table'p'ismarkedasmarkedandshouldberepaired・4,openthetablefailure:Can，topenfile:'x**・myi，(errno:145).5,PreventMySQLtablecorruptionYoucanpreventmysqltablecorruptionbyfollowingth
4、esesteps:RegularlyusemyisamchktochecktheMyISAMtable(noticetoclosemysqld)andrecommendthechecktabletocheckthetable(nottoclosemysqld)・Afterdoingalotofupdatesordeletions,yourecommendusingtheOPTIMIZETABLEtoOPTIMIZEtheTABLEsothatthefilefragmentisreducedandtheprobab
5、ilityofTABLEcorruptionreduced・Beforeclosingtheserver,closethemysqld(normalshutdownservice,donotusethekill-9tokilltheprocess)・Useupspowertoavoidsuddenpoweroutages.Usethelateststablereleaseofmysqltoreducethebugsinmysqlitself.FortheInnoDBengine,youcanuseinnodb_t
6、ablespace_monitortochecktheintegrityofthefilespaceadministrationinthetablespacefile・Doraidondisk,reducediskerrorandhighperformance・Thedatabaseserverisbesttorunonlymysqldandotherservicesthatarenecessary,nottorunotherbusinessservices,thusreducingtheriskofthecra
7、sh.Incaseofaccident,itisagoodideatomakeabackup.RepairofthedamagetotheMySQLtableTheMyISAMtablecanbefixedwiththefollowingsteps:Usereapairtableormyisamchktofixit.Iftheabovemethodisrepairedinvalid,thebackuprecoverytableisadopted.Here'swhatyoucando:Phase1:checkyou
8、rwatchIfyouhavealotoftime,runmyisamchk*•MYIormyisamchk一e*.myi・Usethe-s(silent)optiontodisableunnecessaryinformation.Ifthemysqldserverisdownstate,usethe-update-stateoptiontotellmyisamchkto
