ERROR 1153 (08S01): Got a packet bigger than 'max allowed packet' bytes

ERROR 1153 (08S01): Got a packet bigger than 'max allowed packet' bytes

문제 상황

[root@zetawiki ~]# mysql my_db < my_db.sql -uroot -pP@ssw0rd
ERROR 1153 (08S01) at line 2043: Got a packet bigger than 'max_allowed_packet' bytes

확인

[root@zetawiki ~]# mysql -uroot -pP@ssw0rd -e"SHOW VARIABLES LIKE 'max_allowed_packet'"
+--------------------+---------+
| Variable_name      | Value   |
+--------------------+---------+
| max_allowed_packet | 1048576 |
+--------------------+---------+

재시도

[root@zetawiki ~]# mysql --max_allowed_packet=1000M my_db < my_db.sql -uroot -pP@ssw0rd

참고

• http://stackoverflow.com/questions/93128/mysql-error-1153-got-a-packet-bigger-than-max-allowed-packet-bytes