acoupleofdaysagoicouldn ' tgetmysqltorunanymore (xampp ) aftersomegooglingifoundthispost : xampp-mysqlshutdownunexpectedll
itsaidtoremovetheibdata1filewhichidid，mysqlstartsagainbutthetablesofonedatabasearegone， howevericanstillseethetablesthatcontainvaluesinthedatafolder (ibdandfrmfiles ) isthereanywaythaticanrecoverthosetables？
解决方案
the ibdata 1文件is important，andnormallyyoushouldnotdeleteitunlessyouwanttodropallyourinnnodbdataaandstartoverwithanemptymysqlinsqlinstatioue
evenifyousedinnodb _ file _ per _ table=1andallyourtablesarestoredin.IBD files， the ibdata1filestillcontainsthedatadictation whichisbasicallylikeaglobaltableofcontentsforinnodbtablespaces.it ' showinnodbknodbknononod hichfilestheyreelection ein.the ibdata1filecanalsoincludeimportantdataintherollbacksegmentandchangebuffer，whichwilleventualll
If you have removed ibdata1，andyouhavebeenstoringtabledatainfile-per-table format，it is sometimes possible to recover，butit '
it ' ssimplertorestoreyourmostrecentbackupandthenusethebinarylogtoplaybackchangesmadesubsequentttoyourmostrecentbackup。