I have some MyISAM tables that have backups only of the FRM and MYD files (the MYI files are huge).
Yesterday I needed to restore some of them. To recreate the indexes I followed the procedures under section "4.4.6.9 How to Repair Tables" of MySQL manual. I read and tried everything before the "Stage 3: Difficult repair" but in the end this stage is the one meant for my situation as my index files were missing.
For my most unpleaseant surprise, it didn't work. When I got to the "mysql> TRUNCATE TABLE log_admin_2002;" step I got the following error:
ERROR 1017: Can't find file: 'log_admin_2002.MYD' (errno: 2)
The file exists, it is the the right place, under my temp database directory, both the database directory and the files have the correct permissions and owners, i.e, the same as all my other database directories and tables files.
What is happening?
BTW, my imediate problem is already solved as I recreated the tables from the definition I had in another server as "Stage 4: Very difficult repair" suggests and them manage to get my indexes recreated.
The problem is that I believe the procedures described in "Stage 3: Difficult repair" should work.
I bet I found a bug in MySQL but is there some advice available for my situation?
TIA,
Rodrigo Severo
Some system info:
Conectiva Linux 8 with kernel 2.4.19 gcc version 2.95.3 20010315 (release) MySQL 3.23.56 compiled inhouse
GCC: Reading specs from /usr/lib/gcc-lib/i386-conectiva-linux/2.95.3/specs
gcc version 2.95.3 20010315 (release)
Compilation info: CC='gcc' CFLAGS='-O6 -march=i686 -fomit-frame-pointer' CXX='g++' CXXFLAGS='-O6 -march=i686 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Oct 11 2002 /lib/libc.so.6 -> libc-2.2.4.so
-rw-r--r-- 1 root root 1249256 Jan 29 2002 /lib/libc-2.2.4.so
-rw-r--r-- 1 root root 178 Jan 29 2002 /usr/lib/libc.so
Configure command: ./configure '--enable-assembler' '--with-debug' '--prefix=/usr/local/mysql' '--with-client-ldflags=-all-static' '--with-mysqld-ldflags=-all-static' '--enable-thread-safe-client' '--with-charset=latin1' '--with-extra-charsets=none' '--with-innodb' 'CFLAGS=-O6 -march=i686 -fomit-frame-pointer' 'CXXFLAGS=-O6 -march=i686 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti'
-- ---------------------------------------------------- Rodrigo Severo Fábrica de Idéias Fone: +55(61)321 1357 Fax: +55(61)223 1712 SCS - Quadra 2 - Ed. Empire Center - Sala 1301 Brasília/DF - Brasil CEP: 70.070-904 ----------------------------------------------------
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
