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:
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

[3 Apr 2006 6:08] Jim Michaels
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.
[3 Apr 2006 13:39] MySQL Verification Team
Thank you for the bug report. I was unable to repeat with a fresh

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)

[4 Apr 2006 20:14] Jim Michaels
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.