HELP!!! Lost Connection to MySQL Server Repeatedly 1

[VBRookie]

Please help me! I'm desperate! I can't figure this out! I'm running MySQL 5.0 on WinXP. I have several stored procedures each using a cursor (2 at the most) to move data into several different tables (this is a data migration project).

Shortly after calling my procedure from the mysql command prompt I get this error 2013 about losing my connection to the sql server. I have warnings enabled and wait_timeout set to 50000 but I don't get any errors about a problem with my stored proc.

Please, please, advise. I'm slated to have this new db functional by next week and this has been holding me up terribly. Not to mention causing me to sprout gray hairs and age prematurely.

Your help would be very much appreciated.
Many Thanks,
- VB Rookie

 

[rzs0502]

What tool are you using to query the database?
I used to get the same error on MySQL 5.0.0 on Windows using the MySQL Query browser.
I recenly upgraded to 5.0.15 with the latest MySQL Administrator and Query Browser and the problem went away.
I recall reading that the client libraries of the older version did not understand the new functionality of the version 5 database.
Hope it helps...


"If you always do what you've always done, you will always be where you've always been."

 

[VBRookie]

Thanks for the suggestion rzs0502 ... I tried it but it didn't work ...

 

[rzs0502]

Check

http://bugs.mysql.com/bug.php?id=12979

Seems like it's been fixed in 5.0.13


"If you always do what you've always done, you will always be where you've always been."

 

[VBRookie]

Thanks I've decided to redo the scripts in PHP and just run it from a page instead of the database.

Many Thanks,
- VB Rookie