1. In Navicat for MySQL, when importing a SQL file, an error occurs during execution: 2006 – MySQL server has gone away. See Figure 1.
Plaintext
[SQL] Query object_store start
[ERR] 2006 - MySQL server has gone away
[ERR]
INSERT INTO `telescope_entries` VALUES (1,'94d3463e-0bdc-4642-abaa-a02eaa90ad88','94d34642-03d4-45ed-a058-017813472009',NULL,1,'cache','{\"type\":\"hit\",\"key\":\"options-pre-cache\",\"value\":{\"blogname\":\"naivete32\",\"admin_email\":\"admin@localhost.com\",\"timezone_string\":\"Asia\\/Shanghai\",\"woocommerce_default_customer_address\":\"\",\"woocommerce_currency\":\"USD\",\"customer_service_email\":\"admin@localhost.com\",\"index_seo_title\":\"\",\"index_seo_description\":\"\",\"track_facebook_pixel\":\"\",\"track_ga\":\"\",\"track_google_ads\":\"\",\"track_tiktok_ads\":\"\",\"track_hotjar\":\"\",\"track_lucky_orange\":\"\",\"checkout_member_config\":\"any\",\"checkout_address_2_config\":\"hidden\",\"checkout_phone_config\":\"required\",\"checkout_auto_complete\":\"yes\",\"checkout_edm_config\":\"unchecked\",\"abandoned_checkout_enable\":\"yes\",\"abandoned_checkout_send_after\":\"600\",\"paypal_checkout_position\":\"both\",\"paypal_product_position\":\"no\",\"current_theme\":\"default\",\"auto_tax\":\"yes\",\"password_protected\":\"0\",\"order_number_format\":\"{\\\"prefix\\\":null,\\\"suffix\\\":null}\",\"intelligence_marketing\":\"0\",\"domain_redirect\":\"enable\",\"checkout_setting\":\"three_step_checkout\",\"preferred_payment_method\":\"paypal\",\"payment_icon\":\"[\\\"paypal\\\",\\\"visa\\\",\\\"mastercard\\\",\\\"discover\\\",\\\"dinersclub\\\",\\\"amex\\\"]\"},\"hostname\":\"fpm.object.local\"}','2021-11-08 06:02:54'),(2,'94d3463e-0f1f-429f-b512-0f330e5a8fd5','94d34642-03d4-45ed-a058-017813472009',NULL,1,'cache','{\"type\":\"hit\",\"key\":\"options-pre-cache\",\"value\":{\"blogname\":\"naivete32\",\"admin_email\":\"admin@localhost.com\",\"timezone_string\":\"Asia\\/Shanghai\",\"woocommerce_default_customer_address\":\"\",\"woocommerce_currency\":\"USD\",\"customer_service_email\":\"admin@localhost.com\",\"index_seo_title\":\"\",\"index_seo_description\":\"\",\"track_facebook_pixel\":\"\",\"track_ga\":\"\",\"track_google_ads\":\"\",\"track_tiktok_ads\":\"\",\"track_hotjar\":\"\",\"track_lucky_orange\":\"\",\"checkout_member_config\":\"any\",\"checkout_address_2_config\":\"hidden\",\"checkout_phone_config\":\"required\",\"checkout_auto_complete\":\"yes\",\"checkout_edm_config\":\"unchecked\",\"abandoned_checkout_enable\":\"yes\",\"abandoned_checkout_send_after\":\"600\",\"paypal_checkout_position\":\"both\",\"paypal_product_position\":\"no\",\"current_theme\":\"default\",\"auto_tax\":\"yes\",\"password_protected\":\"0\",\"order_number_format\":\"{\\\"prefix\\\":null,\\\"suffix\\\":null}\",\"intelligence_marketing\":\"0\",\"domain_redirect\":\"enable\",\"checkout_setting\":\"three_step_checkout\",\"preferred_payment_method\":\"paypal\",\"payment_icon\":\"[\\\"paypal\\\",\\\"visa\\\",\\\"mastercard\\\",\\\"discover\\\",\\\"dinersclub\\\",\\\"amex\\\"]\"},\"hostname\":\"fpm.object.local\"}','2021-11-08 06:02:54'),(3,'94d3463e-10b7-42ce-82a5-af8656f8d02e','94d34642-03d4-45ed-a058-017813472009',NULL,1,'cache','{\"type\":\"hit\",\"key\":\"mainDomain\",\"value\":\"object.docker\",\"hostname\":\"fpm.object.local\"}','2021-11-08 14:02:54'),(4,'94d3463e-1134-48ae-a984-2e23c03fed15','94d34642-03d4-45ed-a058-017813472009',NULL,1,'cache','{\"type\":\"hit\",\"key\":\"hosted_domain\",\"value\":\"object.docker\",\"hostname\":\"fpm.object.local\"}','2021-11-08 14:02:54'),(5,'94d3463e-199e-4276-bf08-d0efcb97bc69','94d34642-03d4-45ed-a058-017813472009',NULL,1,'cache','{\"type\":\"missed\",\"key\":\"genealabs:laravel-model-caching::App\\\\Models\\\\Option-cooldown:seconds\",\"hostname\":\"fpm.object.local\"}','2021-11-08 14:02:54'),(6,'94d3463e-1a0f-42d6-8a50-9cf08bf7e323','94d34642-03d4-45ed-a058-017813472009',NULL,1,'cache','{\"type\":\"missed\",\"key\":\"genealabs:laravel-model-caching::App\\\\Models\\\\Option-cooldown:invalidated-at\",\"hostname\":\"fpm.object.local\"}','2021-11-08 14:02:54'),(7,'94d3463e-1a9f-4f0e-a65a-49a4d94cfea6','94d34642-03d4-45ed-a058-017813472009',NULL,1,'cache','{\"type\":\"missed\",\"key\":\"genealabs:laravel-model-caching::App\\\\Models\\\\Option-cooldown:saved-at\",\"hostname\":\"fpm.object.local
[SQL] Finished with error
2. The imported SQL file is about 35MB in size. See Figure 2.
3. The cause is that the default setting for max_allowed_packet is very low. Increase it to 40M in “C:\ProgramData\MySQL\MySQL Server 5.7\my.ini” (in MySQL 5.7, the default is 4194304, which is 4MB).
INI
# The maximum size of one packet or any generated or intermediate string, or any parameter sent by the
# mysql_stmt_send_long_data() C API function.
max_allowed_packet=40M
4. Restart the MySQL service. See Figure 3.
5. Import the SQL file again. The import is successful, and the error no longer occurs. See Figure 4.
