Re: MySQL server has gone away error?

[Gleb Paharenko]

Hello.



Check your MySQL error log. Sever could die during the query.

See:

  http://dev.mysql.com/doc/mysql/en/gone-away.html





Michael [EMAIL PROTECTED] wrote:

 I'm using PHP with MySQL to save files uploaded by users (up to 50MB) to 

 a database. I'm having problems getting MySQL to handle this much data 

 in a single query I guess.

 

 I was getting a *max allowed packet error so I raised that. Now I get a 

 MySQL server has gone away error. Can anyone tell me which setting I 

 probably need to change to make this work? Thanks.

 *

 

 --

 Michael [EMAIL PROTECTED]

 http://kavlon.org

 

 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   ___/   www.mysql.com




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

MySQL server has gone away error?

[Michael]

I'm using PHP with MySQL to save files uploaded by users (up to 50MB) to 
a database. I'm having problems getting MySQL to handle this much data 
in a single query I guess.


I was getting a *max allowed packet error so I raised that. Now I get a 
MySQL server has gone away error. Can anyone tell me which setting I 
probably need to change to make this work? Thanks.

*

--
Michael [EMAIL PROTECTED]
http://kavlon.org


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

MySQL server has gone away error

[Sean Conley]

I posted a couple of days ago abou this error and got no response, so I am
trying again with a bit more detail this time.  I am running mysql
3.23.28-gamma on a pretty much stock RH 6.2 box.  I am accessing the
database using Perl CGI scripts and the DBI API.  I have reset the
max_allowed_packet and wait_timeout values to 10M and 32 hours
respectively as is suggested in the manual, but this has had no
effect.  Here are the specifics from the error logs:

DBD::mysql::st execute failed: MySQL server has gone away at
/cgi-bin/common/utility.pl line 85.

010109 14:37:27  Aborted connection 265218 to db: '' user: ''
host: `localhost' (Got timeout reading communication packets)
010109 14:37:27  /usr/local/libexec/mysqld: Shutdown Complete

010109 14:37:27  mysqld ended\n


Sean Conley


-
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