How do you set "max_allowed_packet" in XAMPP? [closed]
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.
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
精彩评论