Re: Table damaged? And if so how to fix?

[Rick James]

> KEY `lnamedex` (`lname`),
> KEY `lfnamedex` (`lname`,`fname`),
The first is redundant, drop it.

> `MR` varchar(30) DEFAULT NULL,

Is that "Mr."/"Mrs."/...? If so, then the index is useless; drop it.

4 addresses (guarantor/insurance _ 1/2) in one table. Clumsy. Instead, have another table for such, and have up to 4 rows per person in it.

Switch to InnoDB; it is less likely to need repairs, and less likely to lose data.

After making all those changes, your problem should be gone.