List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 27 1999 2:05pm
Subject:Re: Tables continually getting corrupted
View as plain text  
At 1:21 AM -0500 9/27/99, Adrian Sisser wrote:
>I run isamchk with -e.  I don't acutally shutdown mysql to run isamchk.  I
>run mysqladmin flush-tables first.  I know that nobody is altering the table
>while I run the check.  I rarely shutdown the database - only when I reboot
>the system.

Do you also flush-tables *after* running isamchk/myisamchk?  If not, the
server doesn't know you've modified the index file and you have problems.

--
Paul DuBois, paul@stripped
Thread
Tables continually getting corruptedasisser27 Sep
  • Re: Tables continually getting corruptedEd Carp27 Sep
    • Re: Tables continually getting corruptedAdrian Sisser27 Sep
      • Re: Tables continually getting corruptedEd Carp27 Sep
        • Re: Tables continually getting corruptedMichael Widenius27 Sep
      • Re: Tables continually getting corruptedMichael Widenius27 Sep
      • Re: Tables continually getting corruptedPaul DuBois27 Sep