Re: Re: Help! Recovering corrupt table

2002-09-03 Thread Victoria Reznichenko
Rolf, Tuesday, September 03, 2002, 1:57:49 AM, you wrote: >>RH> I'm using MySQL 3.23.51. I have a table which started giving 127 errors. >> >>[skip] >> >>RH> It "recovers" my table but I end up with only 1030 out of 27497 rows, >>RH> so that's not a log of help! >> >>RH> Running myisamchk -r -e g

Re: Help! Recovering corrupt table

2002-09-02 Thread Paul DuBois
At 23:57 +0100 9/2/02, Rolf Howarth wrote: >>RH> I'm using MySQL 3.23.51. I have a table which started giving 127 errors. >> >>[skip] >> >>RH> It "recovers" my table but I end up with only 1030 out of 27497 rows, >>RH> so that's not a log of help! >> >>RH> Running myisamchk -r -e gives a similar r

Re: Help! Recovering corrupt table

2002-09-02 Thread Rolf Howarth
>RH> I'm using MySQL 3.23.51. I have a table which started giving 127 errors. > >[skip] > >RH> It "recovers" my table but I end up with only 1030 out of 27497 rows, >RH> so that's not a log of help! > >RH> Running myisamchk -r -e gives a similar result (only 1030 rows are >RH> recovered), as does

Re: Help! Recovering corrupt table

2002-09-02 Thread Victoria Reznichenko
Rolf, Monday, September 02, 2002, 3:38:06 PM, you wrote: RH> I'm using MySQL 3.23.51. I have a table which started giving 127 errors. [skip] RH> It "recovers" my table but I end up with only 1030 out of 27497 rows, RH> so that's not a log of help! RH> Running myisamchk -r -e gives a similar r

Help! Recovering corrupt table

2002-09-02 Thread Rolf Howarth
I'm using MySQL 3.23.51. I have a table which started giving 127 errors. Running myisamchk -i on it gives: >Checking MyISAM file: /Users/rolf/WBD/back/clip.MYI >Data records: 27497 Deleted blocks: 0 >./bin/myisamchk: warning: 9 clients is using or hasn't closed the >table properly >-