max-allowed-packet – Tarik Billa

increase max_allowed_packet size in mysql docker

May 24, 2023 by Tarik

As an argument to the container command: docker run -it -e MYSQL_ROOT_PASSWORD=my-secret-pw mysql:5.7 –max-allowed-packet=67108864 See “Configuration without a cnf file” at https://hub.docker.com/_/mysql/, copied here for posterity: Configuration without a cnf file Many configuration options can be passed as flags to mysqld. This will give you the flexibility to customize the container without needing a cnf … Read more

MySQL Error 1153 – Got a packet bigger than ‘max_allowed_packet’ bytes

September 13, 2022 by Tarik

You probably have to change it for both the client (you are running to do the import) AND the daemon mysqld that is running and accepting the import. For the client, you can specify it on the command line: mysql –max_allowed_packet=100M -u root -p database < dump.sql Also, change the my.cnf or my.ini file (usually … Read more