• This forum has been archived. New threads and replies may not be made. All add-ons/resources that are active should be migrated to the Resource Manager. See this thread for more information.

How to set “max_allowed_packet” in XAMPP Environment for MySQL

Robert F Schmitz

Well-known member
When importing a database you may get a error due to the max_allowed_packet setting.

To adjust this:

Find xampp/mysql/bin/my.ini
Set the following:

max_allowed_packet = 512M

max_allowed_packet = 512M
Restart MySQL.

The default is usually around 16M

Hope that helps.