Q : While importing database in mysql, an error message pops out "ERROR 1153 (08S01) at line 232: Got a packet bigger than 'max_allowed_packet' bytes"
E.g.
$ mysql5 -u db_user -p db_table < db_table.sql Enter password: ERROR 1153 (08S01) at line 232: Got a packet bigger than 'max_allowed_packet' bytesA : The file importing contains a statement that's probably too big, increase the value "max_allowed_packet" in my.cnf: E.g.
max_allowed_packet = 1Mto
max_allowed_packet = 2MTo find out where's my.cnf in FreeBSD, check out the help page :
mysql --helpand look for the below passage :
Default options are read from the following files in the given order: /etc/my.cnf /etc/mysql/my.cnf /usr/local/etc/my.cnf /usr/local/etc/mysql/my.cnf ~/.my.cnfAs for macports, similarly
mysql5 --helpE.g. :
Default options are read from the following files in the given order: /etc/my.cnf /etc/mysql/my.cnf /opt/local/etc/mysql5/my.cnf ~/.my.cnfCiao !!!
No comments:
Post a Comment