2

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?

1 Answer 1

5

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

1
  • 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 !!! Aug 27, 2011 at 1:59

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .