>Description:
Hello, I've been using MY-SQL with 3 tables, which
all have the same primary key = <CHAR(2), VARCHAR(50)>.
Everything was fine for several months but yesterday I received
an "ERROR 1034" in mysql stating that the key file for
one of the tables was incorrect.
I was able to fix the index with MYISAMCHK but I am reporting
this because I do not know why this error occurred.
>How-To-Repeat:
I am not sure if this error can be easily reproduced.
I have about 35,000 records in the main table and 7,000
records in the second table, and none in the third.
>Fix:
Use MYISAMCHK as documented on the index files for the tables.
>Submitter-Id: Ateendra Balasingham
>Originator: root
>Organization:
>MySQL support: none
>Synopsis: Received Table Error 1034, Unknown to PERROR, Fixed W/MYISAMCHK
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.38 (Official MySQL binary)
>Environment:
System: Linux 2.2.16-3 #2 SMP Mon Dec 18 14:27:09 PST 2000 i686 unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
Compilation info: CC='gcc' CFLAGS='-O3 -mpentium ' CXX='gcc' CXXFLAGS='-O3
-mpentium -felide-constructors' LDFLAGS='-static'
LIBC:
lrwxrwxrwx 1 root root 13 Sep 7 17:25 /lib/libc.so.6 -> libc-2.1.3.so
-rwxr-xr-x 1 root root 4106956 Sep 1 2000 /lib/libc-2.1.3.so
-rw-r--r-- 1 root root 20267724 Sep 1 2000 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Sep 1 2000 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official
MySQL binary' --with-extra-charsets=complex --with-server-suffix= --enable-assembler
--with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared
Perl: This is perl, version 5.005_03 built for i386-linux
---------------------------------------------------------------------
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
