Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

 
discard

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.