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 “SQL/CSV importing error: Got a packet bigger than ‘max_allowed_packet’ bytes”

Posted on
Deprecated: Creation of dynamic property WP_Term::$cat_ID is deprecated in /home/testadnan/adnan.pk/innovator/wp-includes/category.php on line 378

Deprecated: Creation of dynamic property WP_Term::$category_count is deprecated in /home/testadnan/adnan.pk/innovator/wp-includes/category.php on line 379

Deprecated: Creation of dynamic property WP_Term::$category_description is deprecated in /home/testadnan/adnan.pk/innovator/wp-includes/category.php on line 380

Deprecated: Creation of dynamic property WP_Term::$cat_name is deprecated in /home/testadnan/adnan.pk/innovator/wp-includes/category.php on line 381

Deprecated: Creation of dynamic property WP_Term::$category_nicename is deprecated in /home/testadnan/adnan.pk/innovator/wp-includes/category.php on line 382

Deprecated: Creation of dynamic property WP_Term::$category_parent is deprecated in /home/testadnan/adnan.pk/innovator/wp-includes/category.php on line 383
Categories PHPTags , , Leave a comment on SQL/CSV importing error: Got a packet bigger than ‘max_allowed_packet’ bytes