Mysql学习记录 - 导入备份文件报错

ERROR 1406 (22001): Data too long for column 'name_' at row 1
ERROR 1231 (42000): Variable 'sql_mode' can't be set to the value of 'NULL'
ERROR 1231 (42000): Variable 'foreign_key_checks' can't be set to the value of 'NULL'
ERROR 1231 (42000): Variable 'unique_checks' can't be set to the value of 'NULL'
ERROR 1231 (42000): Variable 'sql_notes' can't be set to the value of 'NULL'

原因时导入文件过大,需要修改允许的最大值:

1. 查看最大值

show variables like 'max_allowed_packet';

1. 修改最大值

set global max_allowed_packet = 200 * 1024 * 1024;  (200M)

1. 退出mysql重新登录