change value of max_allowed_packet
Posted by: Kevin Wen
Date: November 14, 2005 04:35PM

Hi,

I created a table using the longblob type. When I used php script to upload the content of file lager than 900K bytes to this column, I got an error message saying that 'The mysql server has gone away'. I thought it could be the default limitation of mysql set by the variable max_allowed_packet, which is 1MB by default in mysql 3.23. How can I change that value? I already got stuck on it for weeks. Any help is very appreciated.

Options: ReplyQuote


Subject
Written By
Posted
change value of max_allowed_packet
November 14, 2005 04:35PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.