开发者

How do you set "max_allowed_packet" in XAMPP? [closed]

This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a sp开发者_如何学JAVAecific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the help center. Closed 10 years ago.

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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜