In Navicat for MySQL, import the SQL file and report an error when executing: 2006 – MySQL Server has gone away
1. In Navicat for MySQL, import the SQL file, and report an error when executing: 2006 – MySQL Server has gone away. as shown in Figure 1
Figure 1
[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 size of the imported SQL file is about 35MB. as shown in Figure 2
Figure 2
3. The reason is that the default settings of max_allowed_packet are very low. In “C:\ProgramData\MySQL\MySQL Server 5.7\My.ini” to increase it to 40M (default in MySQL 5.7 is 4194304, i.e. 4MB.)
# 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. as shown in Figure 3
Figure 3
5. Import the sql file again, the import is successful, and no error will be reported. as shown in Figure 4
Figure 4
