Take the 2-minute tour ×

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?

share|improve this question

1 Answer 1

up vote 5 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).

share|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

Your Answer


