How To Increase Max_allowed_packet Setting?

[IniBudi]

I want to export some csv files from my website. I got an error message when I did export.

I need to increase max_allowed_packet in MySQL setting, but I can't find the file configuration on File Manager.

Can't export CSV
There is either nothing to export, or the number of records may be too large. If it's the latter, try increasing MySQL's max_allowed_packet.

Thank you.

[girish]

@IniBudi currently, max_allowed_packet is hardcoded to 64M . How much does the app require?

[girish]

A workaround is to edit the config in the MySQL container:

docker exec -ti mysql /bin/bash

2. Then, edit /run/mysql/my.cnf
3. In the container shell itself, supervisorctl restart mysql

Note that changes are not persistent across updates (but persists across reboots).