[thelist] mysql alter table tbl_name type=MYISAM

[Michael Mell]

I have some old mysql tables. I've just run
    alter table tbl_name type=MYISAM
on all of them. The data files in the files system still have a ".ISM"
extension and myisamchk says that it can't do anything to the altered
tables because
        myisamchk: error: './theaterRegion.ISM' doesn't have a correct
index definition.
        You need to recreate it before you can do a repair

We're running MySQL 3.23.38
Can any one suggest how to recreate the index definition?

TIA


--
mike[at]nthwave.net
llemekim         YahooIM
415.455.8812     voice
419.735.1167     fax