Database Errors

[BayBay]

 

when adding tables to your mysql if you have error like 
 
MySQL Error 1153 - Got a packet bigger than 'max_allowed_packet' bytes
 
do the following to fix it
 
On CENTOS 6 
"vi /etc/my.cnf" , under [mysqld] section the correct syntax is:
 
[mysqld]
# added to avoid err "Got a packet bigger than 'max_allowed_packet' bytes"
#
net_buffer_length=1000000 
max_allowed_packet=1000000000
#
 
 
then save restart mysql 
 

Thank you soo much CDWriter ill try that right away and ill see what happens.

 

Thanks ALOT CDWriter that totally solved my problem!