If you get such king of error #1153 – Got a packet bigger than ‘max_allowed_packet’ bytes
there are the steps how to fix this
1. login into your server
2. enter into mysql
set this 2 variables
set global max_allowed_packet=1000000000;
set global net_buffer_length=1000000;
3. exit from mysql
4. add this line into my.cnf
max_allowed_packet=16M
5 restart mysql
/etc/init.d/mysql restart
6. upload dump :)
No comments:
Post a Comment