How do you set "max_allowed_packet" in XAMPP?

Question

I've changed it in xampp/mysql/bin/my.ini and still, the effect does not show after restarting MySQL. If I run the following command, it works:

mysql --max_allowed_packet=512M -u root < .\db\dropUser.sql

But, when I browse pages with Drupal, my limit is back to 1Mb, despite the fact that my my.ini file has the value 512 in it.

Answer 1

Was going to delete this, but I figured I'd share the answer. Despite what I said above, I changed the ini file again, this time altering the file to have these two values:

[mysqld]
max_allowed_packet = 512M

[mysqldump]
max_allowed_packet = 512M

Previously I had only altered one of the two. sigh

Answer 2

Your solution did it for me! Thank you so very very much!