#377 change max_allowed_packet size

[Jeff Rule]

I get the following error when browsing a table with
longblob type columns.

Error

SQL-query :

SELECT *
FROM `scaffold`
LIMIT 0 , 30

MySQL said:

#2020 - Got packet bigger than 'max_allowed_packet'

I know I need to increase max_allowed_packet, but I
can't figure out just how to do this.

I have the following entries in the my.cnf file..

------------------------------------------
[mysql]
auto-rehash
set-variable = max_allowed_packet=64M

# The MySQL server
[mysqld]
basedir=/opt/mysql
datadir=/opt/mysql/var
skip-locking
port = 3306
socket = /tmp/mysql.sock
server-id = 1
tmpdir = /opt/data/tmp/
log
log-bin
user=mysql

#set-variable = join_buffer_size=2048M
#set-variable = key_buffer_size=6144M
set-variable = max_allowed_packet=64M
#set-variable = max_connections=512
#set-variable = bulk_insert_buffer_size=64M
#set-variable = myisam_sort_buffer_size=2048M
#set-variable = myisam_max_extra_sort_file_size=512
#set-variable = myisam_max_sort_file_size=6144M
#set-variable = read_buffer_size=512M
#set-variable = read_rnd_buffer_size=512M
#set-variable = sort_buffer_size=2048M
#set-variable = table_cache=512
set-variable = thread_cache_size=32
set-variable = thread_concurrency=32
#set-variable = tmp_table_size=4096M

-------------------------------------------

The settings let me connect to the database with a
standard mysql client and retrieve my data.

However, the phpMyAdmin install on that same machine
does not seem to be picking up the setting... Keep in
mind that this setting needs to be picked up by both
the client and the server.

From my testing... using the show variables like
'max_allowed_packet' always shows the server setting
not the client setting. So, don't be fooled into
thinking it is correct until you try and select a large
field. My items are actuall about 1.7MB in size

[Marc Delisle]

Logged In: YES
user_id=210714

In my.cnf, there is a [client] section. Try setting it there.

[Marc Delisle]

Logged In: YES
user_id=210714

no answer: closed.