Bug #8158 Server crashes whit the "show fields from ..." command
Submitted: 27 Jan 2005 11:01 Modified: 27 Jan 2005 12:27
Reporter: Enrico Schättin Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.2 alpha OS:Windows (Windows 2000)
Assigned to: CPU Architecture:Any

[27 Jan 2005 11:01] Enrico Schättin 
Description:
Hello, 

When I try to dump a database with mysqldump.exe it generates an error and the database falls down (the server crashes). The command show fields from ... creates teh same error/crash.

Example:
C:\mysql\bin\mysqldump.exe -h localhost -u muser --password=mpwd mdatabase >backup-data\database.sql

error-message:
C:\mysql\bin\mysqldump.exe: C:\mysql\bin\mysqldump.exe: Couldn't execute 'show fields from `mtable`': Lost connection to MySQL server during query (2013)

Which is this madness ??? 

System : 

MySQL Alpha 5.0.2 
Windows 2000 

Regards, 
ESCH

How to repeat:
start mysql (console) ->
connect to a database ->
send the command "show fields from xtable" 

or 

try to dump a database with following command
C:\mysql\bin\mysqldump.exe -h localhost -u muser --password=mpwd mdatabase >backup-data\database.sql
[27 Jan 2005 12:27] Aleksey Kishkin 
http://bugs.mysql.com/bug.php?id=8073
[20 Mar 2005 16:08] adrian spinetta 
I have the same problem but also using triggers.