[thelist] mysql alter table tbl_name type=MYISAM

Jay Greenspan jay at trans-city.com
Mon May 13 15:05:00 CDT 2002

You might want to just dump the data, recreate the tables and run the
inserts created by the dump.

I don't why you're getting this error, but I guess that the above action
would fix it.


On Monday, May 13, 2002, at 03:38 PM, Michael Mell wrote:

> 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?
> --
> mike[at]nthwave.net
> llemekim         YahooIM
> 415.455.8812     voice
> 419.735.1167     fax
> --
> For unsubscribe and other options, including
> the Tip Harvester and archive of thelist go to:
> http://lists.evolt.org Workers of the Web, evolt !

More information about the thelist mailing list