I've tried "mysql --set-variable=max_allowed_packet=8M" with no luck.
I'm not getting the error message.
The query has multiple selects. When I copy and paste the query with
4 selects in it, everything's fine. If I try with 5, it dies half way
thru the 5th select as its pastes.
Any more clues greatly appreciated.
cheers
Mark
-------- from the manual----
When a MySQL client or the mysqld server gets a packet bigger than
max_allowed_packet bytes, it issues a Packet too large error and
closes the connection.
If you are using the mysql client, you may specify a bigger buffer by
starting the client with mysql --set-variable=max_allowed_packet=8M.
--------
>There is a limit to the size of a packet sent to mysqld, which is
>configurable. Check the manual for it, and see if you are hitting that.
>
>Regards
>
>Quentin
>
>> -----Original Message-----
>> From: Mark Dale [SMTP:[EMAIL PROTECTED]]
>> Sent: Friday, January 12, 2001 12:39 PM
>> To: [EMAIL PROTECTED]
>> Subject: limit to the number of characters allowed in a query?
>>
>> I'm trying to run a very long query and after trying it in various
>> ways, it seems like there is a limit to the number of characters
>> allowed in a query.
>>
>> If this is true, is it possible to increase the number of characters
>> allowed.
>> (the database is hosted at an ISP)
>>
>> I've tried -q and -f in the query, but it didnt help
>>
>> TIA
>>
> > Mark Dale
>>
---------------------------------------------------------------------
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