for import mysql database give me this error :
$ `mysql -u user -p password zxc_db < zxc.sql`
ERROR 1153 (08S01) at line 96: Got a packet bigger than 'max_allowed_packet' bytes
Please give me a best solution to solve it ? tanx .
the best solution is " change mysql.cnf "
debian :
/etc/mysql/mysql.cnf
change this line ==> max_allowed_packet = 16M
to : max_allowed_packet = 128M
or add --max_allowed_packet=128M to your mysqldump command.
mysql --max_allowed_packet=128M -u user -ppass database < database.sql
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With