- 源数据库来自CPANEL的mysql (8.0.41-cll-lve)
- 导入到AMH的mysql-generic-8.0环境
(1)如果使用madmin直接导入,报错:
[Linux] AMH 7.2
https://amh.sh
[madmin-2.7 admin]
=============================================================
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1153 (08S01) at line 59713: Got a packet bigger than 'max_allowed_packet' bytes
sed: couldn't write 404 items to stdout: Broken pipe
(2)如果使用phpmyadmin导入,报错:
Static analysis:
1 errors were found during analysis.
Missing expression. (near "ON" at position 25)
SQL query: Copy Edit Edit
SET FOREIGN_KEY_CHECKS = ON;
MySQL said: Documentation
#2006 - MySQL server has gone away
看是否导入的数据有过长的sql语句,
在madmin(面板导航『数据』)进入『参数配置』提高max_allowed_packet参数再导入看看。