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

[Matthew Fleming]

Thanks very much for looking at this.

It appears that I can't disable keys, either. The command
ALTER TABLE patients DISABLE KEYS
never returns. It completes in 0.0 sec on my test system.

Here is the result of show create table:
| patients | CREATE TABLE `patients` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`lname` varchar(30) DEFAULT NULL,
`fname` varchar(30) DEFAULT NULL,
`MR` varchar(30) DEFAULT NULL,
`DOB` date DEFAULT NULL,
`log` text,
`SSN` varchar(12) DEFAULT NULL,
`insurance_1_company_name` varchar(60) DEFAULT NULL,
`insurance_1_company_address_line_1` varchar(80) DEFAULT NULL,
`insurance_1_company_address_line_2` varchar(80) DEFAULT NULL,
`insurance_1_policy_no` varchar(40) DEFAULT NULL,
`insurance_1_group_no` varchar(40) DEFAULT NULL,
`guarantor_1_address_line_1` varchar(80) DEFAULT NULL,
`guarantor_1_address_line_2` varchar(80) DEFAULT NULL,
`guarantor_1_home_phone` varchar(35) DEFAULT NULL,
`guarantor_1_relationship` varchar(40) DEFAULT NULL,
`insurance_2_company_name` varchar(60) DEFAULT NULL,
`insurance_2_company_address_line_1` varchar(80) DEFAULT NULL,
`insurance_2_company_address_line_2` varchar(80) DEFAULT NULL,
`insurance_2_policy_no` varchar(40) DEFAULT NULL,
`insurance_2_group_no` varchar(40) DEFAULT NULL,
`guarantor_2_address_line_1` varchar(80) DEFAULT NULL,
`guarantor_2_address_line_2` varchar(80) DEFAULT NULL,
`guarantor_2_home_phone` varchar(35) DEFAULT NULL,
`guarantor_2_relationship` varchar(40) DEFAULT NULL,
`pt_address_line_1` varchar(80) DEFAULT NULL,
`pt_address_line_2` varchar(80) DEFAULT NULL,
`pt_address_city` varchar(40) DEFAULT NULL,
`pt_address_state` varchar(2) DEFAULT NULL,
`pt_address_zip` varchar(10) DEFAULT NULL,
`pt_phone_home` varchar(35) DEFAULT NULL,
`pt_phone_business` varchar(35) DEFAULT NULL,
`sex` char(1) DEFAULT NULL,
`guarantor_1_address_city` varchar(40) DEFAULT NULL,
`guarantor_2_address_city` varchar(40) DEFAULT NULL,
`insurance_2_address_city` varchar(40) DEFAULT NULL,
`insurance_1_address_city` varchar(40) DEFAULT NULL,
`insurance_1_address_state` varchar(2) DEFAULT NULL,
`insurance_2_address_state` varchar(2) DEFAULT NULL,
`guarantor_2_address_state` varchar(2) DEFAULT NULL,
`guarantor_1_address_state` varchar(2) DEFAULT NULL,
`guarantor_1_address_zip` varchar(10) DEFAULT NULL,
`guarantor_2_address_zip` varchar(10) DEFAULT NULL,
`insurance_2_address_zip` varchar(10) DEFAULT NULL,
`insurance_1_address_zip` varchar(10) DEFAULT NULL,
`insurance_2_name_of_first` varchar(40) DEFAULT NULL,
`insurance_2_name_of_last` varchar(40) DEFAULT NULL,
`insurance_1_name_of_last` varchar(40) DEFAULT NULL,
`insurance_1_name_of_first` varchar(40) DEFAULT NULL,
`guarantor_2_name_first` varchar(40) DEFAULT NULL,
`guarantor_2_name_last` varchar(40) DEFAULT NULL,
`guarantor_1_name_last` varchar(40) DEFAULT NULL,
`guarantor_1_name_first` varchar(40) DEFAULT NULL,
PRIMARY KEY (`ID`),
KEY `lnamedex` (`lname`),
KEY `lfnamedex` (`lname`,`fname`),
KEY `DOBdex` (`DOB`),
KEY `MRdex` (`MR`)
) ENGINE=MyISAM AUTO_INCREMENT=99199 DEFAULT CHARSET=latin1 |

Any assistance would be gratefully appreciated.

Matthew Fleming, MD