larger than
max_allowed_packet from server configuration of 65536 bytes
---
I m using Redhat 7.3, mysql-3.23.51-max with custom kernel.
The same thing works on my other machine with the same OS and same mysql
version but default RH 7.3 kernel. Is this
> i!='AP' AND i != 'J3' AND...to 5000).
>
> >
>
> > When I try to execute the Query I get the error:
>
> >
>
> > "Packet is Larger than max_allowed_packet from server configuration of
> 65536
>
> > bytes"
>
>
ql server or client.
> I have a very large query that I need to send to MySQL from Java. The query
> has approximately 5000 individual items in the where clause. (i.e. WHERE
> i!='AP' AND i != 'J3' AND...to 5000).
>
> When I try to execute the Que
I try to execute the Query I get the error:
"Packet is Larger than max_allowed_packet from server configuration of 65536
bytes"
I read the MySQL documentation and increased my max_allowed_packet to 24M on
both the client and the Server in the my.cnf, but I still get the same
errorIs