"myisamchk -r" hanging for a long time after fixing indexes

We have a database running Invision Power Board. The table containing the posts (>3.000.000 rows) keeps on crashing from time to time, and the index gets corrupt. We stop mysql, and run "myisamchk -r tablename", which behaves strangely. First it uses 3-5 minutes fixing the inde

R: myisamchk -R

Thnks a lot Patrizio -Messaggio originale- Da: Egor Egorov [mailto:[EMAIL PROTECTED] Inviato: lunedì 21 luglio 2003 14.02 A: [EMAIL PROTECTED] Oggetto: Re: myisamchk -R "PaT!" <[EMAIL PROTECTED]> wrote: > > I need a hint how to use myisamchk > > I use t

Re: myisamchk -R

"PaT!" <[EMAIL PROTECTED]> wrote: > > I need a hint how to use myisamchk > > I use this syntax in a shell but it doesn't work > > myisamchk -R=ID \mysql\data\db\mytable.myi > > ID is the index name I want to use to sort the table > >

myisamchk -R

Hi, I need a hint how to use myisamchk I use this syntax in a shell but it doesn't work myisamchk -R=ID \mysql\data\db\mytable.myi ID is the index name I want to use to sort the table I'm using mysql 4.0.13 on Win 2K server Thanks for help Patrizio