ERROR 1153 (08S01) at line xxxx: Got a packet bigger than ‘max_allowed_packet’ bytes
Oct 13, 2007 in mysql
Al ejecutar un script sql puede aparecer este error:
ERROR 1153 (08S01) at line 40699: Got a packet bigger than ‘max_allowed_packet’ bytes
Lanzamos esta consulta para ver el limite
mysql -uadmin -p`cat /etc/psa/.psa.shadow ` -e "show variables like '%max_allowed%'"
+--------------------+---------+ | Variable_name | Value | +--------------------+---------+ | max_allowed_packet | 1048576 | +--------------------+---------+
Para solucionarlo ampliamos el limite sólo para la consulta:
mysql -u admin -p`cat /etc/psa/.psa.shadow ` --max_allowed_packet=256M database < export.sql