Lost connection to MySQL server during query - pls help

[Kiky]

Hi Guys,
I have a problem with 
"Error 2013 - Lost connection to MySQL server during query"

I'm using mysql 3.23.41 under Linux Mandrake, and mysql 4.0.15 under Win XP Pro.
They turn out to have the same error.

My problem is:
I have a Java program which is actually a thread to send emails, so it keeps running 
all the time.
When it's time to send emails, it will access MySQL database.
Based on my wait_timeout in mysql, I think the connection closes after 8 hrs.
If it's the time to send emails, and mysql has already closed the connection, the 
first connection attemp will throw an error
"Error 2013 - Lost connection to MySQL server during query"

* Is there a way that I can avoid this error? Or to make the connection keeps open all 
the the time?

Any help / suggestions will be very much appreciated :)

Thank you in advance.

Rgds,
Vanessa

Re: Lost connection to MySQL server during query - pls help

[Kiky]

Thank you so much guys, for your attention and help.
I'm upgrading my MySQL to 4.0.16 as suggested.

Rgds,
Vanessa

- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Jay Blanchard" <[EMAIL PROTECTED]>; "miguel
solorzano" <[EMAIL PROTECTED]>; "Kiky" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Saturday, December 06, 2003 12:56 AM
Subject: RE: Lost connection to MySQL server during query - pls help


> At 10:44 -0600 12/5/03, Jay Blanchard wrote:
> >[snip]
> >Please upgrade you MySQL Windows client to 4.0.16 there is a bug
> >with net_read_timeout and net_write_timeout on 4.0.15 that
> >disconnect when the query takes more than 30 secons.
> >[/snip]
> >
> >Can you elaborate on this, we have not seen this problem
>
> See the "Bugs fixed" section of:
>
> http://www.mysql.com/doc/en/News-4.0.16.html
>
> --
> Paul DuBois, Senior Technical Writer
> Madison, Wisconsin, USA
> MySQL AB, www.mysql.com
>
> Are you MySQL certified?  http://www.mysql.com/certification/
>
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

From Windows access to MySQL on Linux

[Kiky]

Dear all,
I have to work wih PHP on Win 98/Win 2K, but I have to access
MySQL on Linux.
At the first time, I was trying to use ASP and using ODBC to access
MySQL on Linux, but the problem is that installing additional
components, even for MySQL driver - ODBC is not allowed by our company
policy.
My question is that : is it possible to have a direct access to MySQL on
Linux, if I use PHP on Windows ?
Direct access I mean here is : the same access support if I put PHP and
MySQL both on Linux (no ODBC needed, etc).

Any help would be very much appreciated.

Sincerely,
Helen



-
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

Re: From Windows access to MySQL on Linux

[Kiky]

Thank you for your reply :-)

> Yes, you can add a mysql user that has access to mysql server from the
> windows host and use this user to create the connection.

## Is it possible to do this in PHP under Windows, without installing
any
mysql driver for ODBC, or any other additional installation ?
Can I  just do the same way of connection to mysql database, just like
the one
I use in PHP under Linux ?

mysql_connect("127.0.0.1", "root", "");
mysql_select_db("my_database")

Thank you,
Helen

-
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 
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php