Could you include the error you receive?

You can check the current value of your max_allowed_packet using the
following command,

mysql> show variables like 'max_allowed_packet';

max_allowed_packet determines the maximum packet length that the server
can send and receive.

You can set this value to something other than the default using,

mysql> set max_allowed_packet=1048576;

To make the change more permanent you can add a line to /etc/my.cnf in
the [mysqld] section of that config file and restart the server.

Regards
Mark.

-----Original Message-----
From: Mike At Spy [mailto:[EMAIL PROTECTED] 
Sent: 31 October 2003 15:04
To: [EMAIL PROTECTED]
Subject: Max Packet for MySQL?


I'm getting the error:

When uploading a file in my PHP code to a mysql table.

>From what I've read, this has to do with the max_allowed_packet variable
in
mysql.  How can I tell what that packet variable is set to?

Do I have to re-compile mysql to change it?  Or is there a config file
(linux OS) I can change it in and restart the server?

Thanks For Any Help,

-Mike



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


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

Reply via email to