[thelist] mysql alter table tbl_name type=MYISAM

Michael Mell mike at nthwave.net
Mon May 13 14:39:02 CDT 2002

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?


llemekim         YahooIM
415.455.8812     voice
419.735.1167     fax

More information about the thelist mailing list