up vote 2 down vote favorite
share [g+] share [fb]

I recently had a table in my MySQL DB go haywire (part of my Invision Power Board install) which has never happened to me before. If I use the "Repair" tool in phpMyAdmin, will I run the risk of data loss? Is there a more graceful way to restore the table to it's previous state?

link|improve this question
feedback

1 Answer

up vote 4 down vote accepted

I assume you are using MyISAM storage engine which is not transactional, so the risk of data loss is implied. But repairing a corrupted MyISAM table is a standard procedure, so you should not lose more than several latest records (usually one or two).

link|improve this answer
Very true. In fact, if the MyISAM is ROW_FORMAT is FIXED, there is an even lower incidence of data loss after REPAIR TABLE. +1 !!! – RolandoMySQLDBA Aug 27 '11 at 1:59
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.