mysql提示1153Got a packet bigger than ‘max_allowed_packet’

今天自己的网站在导入导出数据库的时候发现有几十个错误，查看错误提示1153Got a packet bigger than ‘max_allowed_packet’。原来是mysql.ini默认设置文件，
打开mysql.ini查找max_allowed_packet 

[mysqldump]
quick
max_allowed_packet = 16M

[wampmysqld]
port = 3306
socket = /tmp/mysql.sock
key_buffer = 16M
max_allowed_packet = 1M

话不多说  我网站的数据库文件有30M 

那我就修改下配置


[mysqldump]
quick
max_allowed_packet = 50M

[wampmysqld]
port = 3306
socket = /tmp/mysql.sock
key_buffer = 16M
max_allowed_packet = 50M
然后重启apache，在次导入测试




完美解决1153错误提示问题