ERROR 1153 (08S01) at line xxxx: Got a packet bigger than ‘max_allowed_packet’ bytes

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[/shell]

mysql -uadmin -p`cat /etc/psa/.psa.shadow ` -e "show variables like '%max_allowed%'"[/shell]

+--------------------+---------+

| Variable_name      | Value   |

+--------------------+---------+

| max_allowed_packet | 1048576 |

+--------------------+---------+[/shell]

Para solucionarlo ampliamos el limite sólo para la consulta:[/shell]

[shell]mysql -u admin -p`cat /etc/psa/.psa.shadow ` --max_allowed_packet=256M database < export.sql[/shell][/shell]