MySQL Bugs: #18724: mysql.exe disconnects from server on 7MB script with BLOBs

Bug #18724	mysql.exe disconnects from server on 7MB script with BLOBs
Submitted:	3 Apr 2006 6:08	Modified:	4 Apr 2006 20:14
Reporter:	Jim Michaels	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	5.0.19 GA comm. edition, essential x86	OS:	Windows (Windows XP Pro MP)
Assigned to:		CPU Architecture:	Any

Description:
http://mmediap3.home.comcast.net/z/sql.zip is the script. was generated by Administrator 1.1.7 backup. restores fine with Administrator 1.1.9.

this script has multiple databases, so mysqlimport doesn't seem to work. :-(

somewhere in the middle, mysql.exe starts spouting all sorts of odd errors, and disconnects itself from the server. the server then locks out mysql.exe from access. (QB 1-liners work though).  QB script executions also break the same way.

a reboot fixes the access problem. (restarting the service doesn't fix this)

How to repeat:
start with fresh install of mysql.
run mysql.exe and login as root.
'source' the script file.

Thank you for the bug report. I was unable to repeat with a fresh
install:

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| brendas            |
| demodynamic        |
| geoff-blog         |
| jmichae3           |
| lc_events          |
| mysql              |
| test               |
+--------------------+
8 rows in set (0.00 sec)

mysql> select version();
+-----------+
| version() |
+-----------+
| 5.0.19-nt |
+-----------+
1 row in set (0.00 sec)

mysql>

this is an edited script. the original version I had included information_schema (a big mistake) in it. backup includes this table last.
my correction would be to backup/restore & include information_schema in it, but the server chokes on information_schema for what seems like (obvious?) reasons.
if this shouldn't be a problem, try it.