Problem Description
I am having a problem with BLOB fields in my MySQL database - when uploading files larger than approx 1MB I get an error `Packets larger than max_allowed_packet are not allowed.`
Here is what i've tried:
In MySQL Query Browser I ran a `show variables like 'max_allowed_packet'` which gave me 1048576.
Then I execute the query `set global max_allowed_packet=33554432` followed by `show variables like 'max_allowed_packet'` - it gives me 33554432 as expected.
But when I restart the MySQL server it magically goes back to 1048576. What am I doing wrong here?
Bonus question, is it possible to compress a BLOB field?
AI-Generated Solution
Powered by LMSouq AI · GPT-4.1-mini
Analyzing problem and generating solution…
Was this solution helpful?