Re: Table damaged? And if so how to fix?
Posted by:
Rick James
Date: April 12, 2014 02:23PM
Strange.
> Unfortunately, after some web searching I can't figure out what to do with this information.
Unfortunately, I have run out of ideas, other than the desparate ones:
* restart mysql (should take very few seconds);
* if that did not solve it, then reboot
Those _should_ not be necessary, but it does smell like that table is wedged somehow, and the wedging _may_ be in the OS, not MySQL.
Here is another "solution". (I admit that it is ugly in your case.)
Create a 'parallel' table with the same PK (ID) as `patients`, plus `MR` with the new VARCHAR(50) and copy the existing data from `patients` to the new table. Then change the code to JOIN to the new table whenever you need MR. INSERTs and UPDATEs will be messy. Then simply leave the old MR behind.