I have been trying to change my max_allowed_packet size, but for some reason it won't stay. It's currently set at 1mb (default) and I need it at 16mb to match the blob size in my file upload database. I've got it to change for about ~30 min before, but then it reverts back.
I've done "set max_allowed_packet 16777216;" in a mysql shell connection, add "MAX_ALLOWED_PACKET=16777216" to my.conf files, reset the sql server, and still it won't stay permanent.
How do you change the max_allowed_packet size? I'm new to server control and set-up type things, so I'm kind of at a loss. Thanks