SQL/CSV importing error: Got a packet bigger than ‘max_allowed_packet’ bytes

I got this error today when I was importing a CSV file in MYSQL using phpMyAdmin. This error can be with SQL importing as well. It appears because of some (let’s say description) field needs to extend its length. After searching a lot on web, I found I would need to edit my.cnf file variable ‘max_allowed_packet’ to maximum bytes. If you are doing this on your local machine or VPS you can edit file directly. but there is another nicer way to do that. Continue reading