Good morning. I use MySQL version 5.5.20 on a WAMP server.
I have a SQL statement that needs a little more memory than it has been set by default, to return the data.
So I increased the value of max_allowed_packet to the size I need in my.ini , and restart services.
I make this select to confirm the saved information: Select @@global.max_allowed_packet , all right.
But the next day the settings go back to what they were before.
You've gone through this or you can give me an idea how to solve it.
Note: I have already tried to set the global value of this mode: set global max_allowed_packet = valor , but the same thing happens above.
Thank you very much.