_____________________________________________________
Win98 4.10.98, AMD Duron, 128 MB RAM
MySQL 3.23.39 running on localhost
_____________________________________________________
Query is
DELETE FROM staticStrings
WHERE ruri LIKE 'staticAnzeigen%'
_____________________________________________________
Error is
Lost connection to MySQL server during query
_____________________________________________________
WinMySQLadmin crashes with the following message:
MYSQLD-OPT verursachte einen Fehler durch eine ungültige Seite
in Modul MYSQLD-OPT.EXE bei 017f:0047e56a.
Register:
EAX=00000000 CS=017f EIP=0047e56a EFLGS=00010246
EBX=409f7604 SS=0187 ESP=0178f2d0 EBP=00a8330a
ECX=00000000 DS=0187 ESI=409f7505 FS=ccff
EDX=00000001 ES=0187 EDI=009f7f68 GS=0000
Bytes bei CS:EIP:
_____________________________________________________
isamchk -s ../var/pferdezeitung/staticStrings.ISM
C:\mysql\bin>isamchk -s ..\data\pferdezeitung\staticStrings.ism
C:\MYSQL\BIN\ISAMCHK.EXE: ISAM file ..\data\pferdezeitung\staticStrings.ism
C:\MYSQL\BIN\ISAMCHK.EXE: error: Size of indexfile is: 13312 Should be
: 15360
C:\MYSQL\BIN\ISAMCHK.EXE: error: Size of datafile is: 778515 Should be
: 839240
C:\MYSQL\BIN\ISAMCHK.EXE: error: Found key at page 1024 that points to record ou
tside datafile
C:\MYSQL\BIN\ISAMCHK.EXE: error: Record-count is not ok; is 27 Should
be: 28
C:\MYSQL\BIN\ISAMCHK.EXE: warning: Found 28 parts Should
be: 29 parts
ISAM-table '..\data\pferdezeitung\staticStrings.ism' is corrupted
Fix it using switch "-r" or "-o"
_____________________________________________________
-r shows
C:\mysql\bin>isamchk -r ..\data\pferdezeitung\staticStrings.ism
- recovering ISAM-table '..\data\pferdezeitung\staticstrings.ism'
Data records: 28
- Fixing index 1
- Fixing index 2
Data records: 27
_____________________________________________________
in consequence the error is gone and WinMySQLadmin doesn't crash.
I uploaded the table files, if you need a superb crashed table.
As I didn't have an ftp account and creation of such didn't work
as it should, I worked it out as follows:
You can get
http://art-quarter.com/staticstrings.ism
and
http://art-quarter.com/staticStrings.frm
directly, but
http://art-quarter.com/staticstrings.ISD
does not work in the browser, so I created
http://art-quarter.com/crashedTable.php3
which does not work with IE, but fine with Netscape, so please
use that if you need it - I have several complaints about IE and
workarounds, but none works for me, so I give up.
Hope that helps.
--
Herzlich
Werner Stuerenburg
_________________________________________________
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de
---------------------------------------------------------------------
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
