CPANEL的mysql (8.0.41-cll-lve) 的数据库导入到AMH报错?????

  1. 源数据库来自CPANEL的mysql (8.0.41-cll-lve)
  2. 导入到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
阅读 312
1 个回答

看是否导入的数据有过长的sql语句,
在madmin(面板导航『数据』)进入『参数配置』提高max_allowed_packet参数再导入看看。

撰写回答
你尚未登录,登录后可以
  • 和开发者交流问题的细节
  • 关注并接收问题和回答的更新提醒
  • 参与内容的编辑和改进,让解决方法与时俱进
推荐问题