2 messages in com.mysql.lists.bugsRe: Mysql 3.23.27 & auto repair
FromSent OnAttachments
Peter Zaitsev31 Oct 2000 11:35 
sin...@mysql.com01 Nov 2000 05:14 
Subject:Re: Mysql 3.23.27 & auto repair
From:sin...@mysql.com (sin@mysql.com)
Date:11/01/2000 05:14:43 AM
List:com.mysql.lists.bugs

Peter Zaitsev writes:

Hello bugs,

One more problem with auto repair: Easy to repeat:

Then the data (MYD) file for the table is lost mysql core dumps then tryes to check it:

-rw-rw---- 1 mysql 514 3564544 Oct 31 08:53 g06pages.MYI -rw-rw---- 1 mysql 514 8888 Aug 16 12:08 g06pages.frm

I just do select(*) from g06pages or just use database, this table is located in.

-- Best regards, Peter mailto:pz@spylog.ru

Hi!

Will you please elucidate.

I have tried select * from table1, where table1.MYD was deleted and I have got the error message. Nothing crashed.

What was exactly a precedure that caused a crash ??

Regards,

Sinisa

____ __ _____ _____ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sin@mysql.com /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ /*/ \*\ Developers Team