When trying to insert a database I got the following error:
“ERROR 1153 (08S01) at line 69: Got a packet bigger than ‘max_allowed_packet’ bytes”
This is due to the database being too large. To fix:
Enter MySQL:
- mysql -p
Then run the following:
- set global net_buffer_length=1000000;
- set global max_allowed_packet=1000000000;