Myisamchk can't repair table help help help
Arrrggghhh! This is definitely a problem! Can't access table White in mysql 4.0.1: table is read-only. why? because it's corrupt! Try to fix: takes a long time (about an hour) and seems to work. But it's still corrupt and read-only: [root@db1 elenco4_fb02]# myisamchk White; Checking MyISAM file: White Data records: 22079089 Deleted blocks: 0 - check file-size - check key delete-chain - check record delete-chain - check index reference - check data record references index: 1 - check data record references index: 2 - check data record references index: 3 - check data record references index: 4 - check data record references index: 5 - check data record references index: 6 - check data record references index: 7 - check data record references index: 8 - check record links myisamchk: warning: Found 22079089 partsShould be: 0 parts MyISAM-table 'White' is usable but should be fixed [root@db1 elenco4_fb02]# echo $TMPDIR [root@db1 elenco4_fb02]# TMPDIR=/var/lib/mysql/tmp [root@db1 elenco4_fb02]# echo $TMPDIR /var/lib/mysql/tmp [root@db1 elenco4_fb02]# export TMPDIR [root@db1 elenco4_fb02]# myisamchk -q -r --force --fast -O sort_buffer=64M White - check key delete-chain - check record delete-chain - recovering (with sort) MyISAM-table 'White' Data records: 22079089 - Fixing index 1 - Fixing index 2 - Fixing index 3 - Fixing index 4 - Fixing index 5 - Fixing index 6 - Fixing index 7 - Fixing index 8 [root@db1 elenco4_fb02]# ls -l total 7001668 -rwxrwxr-x1 root root0 Feb 27 01:30 Counts.MYD -rwxrwxr-x1 root root 1024 Feb 27 01:30 Counts.MYI -rwxrwxr-x1 root root 8578 Feb 27 01:30 Counts.frm -rwxrwxr-x1 root root 409097196 Feb 27 01:30 Invfile.MYD -rwxrwxr-x1 root root 314644480 Feb 27 01:28 Invfile.MYI -rwxrwxr-x1 root root 8612 Feb 27 01:27 Invfile.frm -rwxrwxr-x1 root root 1964830232 Feb 27 19:19 White.MYD -rwxrwxr-x1 root root 2079708160 Feb 27 22:11 White.MYI -rwxrwxr-x1 root root 9159 Feb 27 01:18 White.frm [root@db1 elenco4_fb02]# myisamchk -U White; Checking MyISAM file: White Data records: 22079089 Deleted blocks: 0 - check file-size - check key delete-chain - check record delete-chain - check index reference - check data record references index: 1 - check data record references index: 2 - check data record references index: 3 - check data record references index: 4 - check data record references index: 5 - check data record references index: 6 - check data record references index: 7 - check data record references index: 8 - check record links myisamchk: warning: Found 22079089 partsShould be: 0 parts MyISAM-table 'White' is usable but should be fixed [root@db1 elenco4_fb02]# - 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
Re: Myisamchk can't repair table help help help
Steve Rapaport wrote: Arrrggghhh! This is definitely a problem! Can't access table White in mysql 4.0.1: table is read-only. why? because it's corrupt! Try to fix: takes a long time (about an hour) and seems to work. But it's still corrupt and read-only: [cut] [root@db1 elenco4_fb02]# ls -l total 7001668 -rwxrwxr-x1 root root0 Feb 27 01:30 Counts.MYD -rwxrwxr-x1 root root 1024 Feb 27 01:30 Counts.MYI -rwxrwxr-x1 root root 8578 Feb 27 01:30 Counts.frm -rwxrwxr-x1 root root 409097196 Feb 27 01:30 Invfile.MYD -rwxrwxr-x1 root root 314644480 Feb 27 01:28 Invfile.MYI -rwxrwxr-x1 root root 8612 Feb 27 01:27 Invfile.frm -rwxrwxr-x1 root root 1964830232 Feb 27 19:19 White.MYD -rwxrwxr-x1 root root 2079708160 Feb 27 22:11 White.MYI -rwxrwxr-x1 root root 9159 Feb 27 01:18 White.frm [cut] Does your system have support for files larger than 2GB? -- Mihail Manolov Solutions Architect Government Liquidation, LLC www.govliquidation.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
