Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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


By posting your answer, you agree to the privacy policy and terms of service.

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