Re: Persistent Corruption [UPDATE]

2005-08-04 Thread Chris McKeever
thanks for everyone help/suggestions -- I wound up swapping the media, and what was corrupt prior, seems to be all nice and happy now -- so - as suggested, looks to be that the drive was starting to fault On 7/31/05, Chris McKeever <[EMAIL PROTECTED]> wrote: > Thanks for all the help - I tried th

Re: Persistent Corruption

2005-07-31 Thread Chris McKeever
Thanks for all the help - I tried the dump as suggested, and it still corrupted...waiting on the new drive to come and then I will try replacing that .. I hope that I dont have to move to a new kernel!! On 7/29/05, Terence <[EMAIL PROTECTED]> wrote: > Also check your kernel version. We had the s

Re: Persistent Corruption

2005-07-29 Thread Terence
Also check your kernel version. We had the same problems running on the old RH 7.3 kernel (2.4.17 was it?) After upgrading to RH9 it was fine. Chris McKeever wrote: MySQL 4.0.16 I am having this annoying persistent corruption issue, and am wondering if anyone has any suggestions. I have two t

Re: Persistent Corruption

2005-07-28 Thread Gleb Paharenko
Hello. > MySQL 4.0.16 You run an old MySQL. Upgrade to the latest release sometimes solves such issues. Check if the problem remains with MySQL 4.1.13 (or 4.0.25). Chris McKeever <[EMAIL PROTECTED]> wrote: > MySQL 4.0.16 > > I am having this annoying persistent corruption issue,

Re: Persistent Corruption

2005-07-28 Thread Chris McKeever
On 7/28/05, Dan Tappin <[EMAIL PROTECTED]> wrote: > I was running into this all the time. > > I actually had myisamchk running on a regular basis (live) via cron > which I think was actually causing the corruption. > > By chance are you running myisamchk on the live tables?? I was - but not aft

Re: Persistent Corruption

2005-07-28 Thread Dan Tappin
I was running into this all the time. I actually had myisamchk running on a regular basis (live) via cron which I think was actually causing the corruption. By chance are you running myisamchk on the live tables?? I ran the REPAIR TABLE... on each table, shut down mysql THEN ran myisamchk

Re: Persistent Corruption

2005-07-28 Thread Chris McKeever
On 7/28/05, Dobromir Velev <[EMAIL PROTECTED]> wrote: > Hi, > Isn't there some information in the MySQL error log about what might have > caused the corruption. Normally this would happen when disk or memory problem > occurs. > thanks for the reply - from the .err file: 050722 5:20:24 read_n

Re: Persistent Corruption

2005-07-28 Thread Dobromir Velev
Hi, Isn't there some information in the MySQL error log about what might have caused the corruption. Normally this would happen when disk or memory problem occurs. On Thursday 28 July 2005 17:45, Chris McKeever wrote: > MySQL 4.0.16 > > I am having this annoying persistent corruption issue, and