Grzegorz Paszka writes:
> Hi.
>
> I've problem with mysql.
>
> I had i386 RH71 (kernel 2.4.13, 1.5GB RAM, single procesor) with mysql 3.23.36 (now
>I have 3.23.41 and problem still exists).
> I run myisamchk on table zawartosc:
>
> [root@tygrys rpm]# myisamchk -c -i -v -w zawartosc
> Checking MyISAM file: zawartosc
> Data records: 6995929 Deleted blocks: 0
> - check file-size
> - check key delete-chain
> block_size 1024:
> - check record delete-chain
> No recordlinks
> - check index reference
> - check data record references index: 1
> Key: 1: Keyblocks used: 98% Packed: 0% Max levels: 4
> - check data record references index: 2
> Key: 2: Keyblocks used: 65% Packed: 60% Max levels: 7
> Total: Keyblocks used: 69% Packed: 56%
>
> - check record links
> myisamchk: error: Checksum for key: 2 doesn't match checksum for records
>
> Record blocks: 6995929 Delete blocks: 0
> Record data: 398291567 Deleted data: 0
> Lost space: 5259802 Linkdata: 26232723
> MyISAM-table 'zawartosc' is corrupted
> Fix it using switch "-r" or "-o"
>
> Of course I used switch -r and problem still exists.
> Second I used switch -o and problem still exists.
>
Hi!
I hope you have not run myisamchk while server was running ????
If yes, then that would explain things. Try using CHECK TABLE SQL
command instead.
Do you want to say that there is no way that you can repair MyISAM
table ??
In that case there is in our fine manual a description of how to solve
most critical table corruption. This basically involves rebuilding of
entire index file.
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
