During restores of MySQL databases, the default packet buffer size defined in the max_allowed_packet variable for the MySQL server is used. You can increase the value of max_allowed_packet for the restore.
To add or edit an additional setting, follow the steps in Add or Modify an Additional Setting.
Use these arguments:
-
In the Name box, enter sAdvancedRestoreOptions. The Category and Type details fill automatically.
-
In the Value box, enter the appropriate value, for example, --max_allowed_packet=1GB.