How To Increase Max_allowed_packet Setting?
-
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.
-
A workaround is to edit the config in the MySQL container:
docker exec -ti mysql /bin/bash- Then, edit
/run/mysql/my.cnf - In the container shell itself,
supervisorctl restart mysql
Note that changes are not persistent across updates (but persists across reboots).
- Then, edit
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login