Shulou(Shulou.com)06/03 Report--

The database version is Mariadb 5.5.It is managed by K8S.

Mysql-uroot-p xxxx < xxxxx.sql

Prompt locally

ERROR 2013 (HY000) at line 1320: Lost connection to MySQL server during query

This is because only 16MB is the default max_allow_packet for mysql, so we add a line to the configuration file of mysql

Max_allowed_packet=100M

Or modify the args parameter under pod

Args: ["- character-set-server=utf8mb4", "--collation-server=utf8mb4_unicode_ci", "--event_scheduler=ON", "--max_allowed_packet=100M", "--skip-name-resolve"]

Just add a "--max_allowed_packet=100M"

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.