今天在用Navicat导入SQL文件时报错:MySql 错误 Err [Imp] 1153 - Got a packet bigger than 'max_allowed_packet' bytes
查了一下,原来是MySQL默认读取执行的SQL文件最大为16M,我这个SQL文件260M,所以执行不过去
解决方法:
在MySQL安装目录下找到文件my.ini,搜索[mysqld],在其下面添加一句话
max_allowed_packet=400M
重启MySQL服务
这个大小按自己的SQL文件大小而设
相关推荐
libcom_err-1.41.12-23.el6.x86_64.rpm libcom_err-1.41.12-23.el6.x86_64.rpm
centos6,linux系统,rpm资源:libcom_err-1.41.12-24.el6.x86_64.rpm
openssl-devel-packages\libcom_err-1.41.12-22.el6.x86_64.rpm openssl-devel-packages\libcom_err-devel-1.41.12-22.el6.x86_64.rpm openssl-devel-packages\libselinux-2.0.94-5.8.el6.x86_64.rpm openssl-...
离线安装包,亲测可用
离线安装包,亲测可用
libcom_err-devel-1.42.9-19.el7.i686.rpm
centos6,linux系统,rpm资源:libcom_err-devel-1.41.12-24.el6.x86_64.rpm
错误 101 (net--ERR_CONNECTION_RESET).docx
安装krb5-devel-1.15.1-50.el7.x86...2、 libcom_err-devel-1.42.9-19.el7.x86_64.rpm 3、 libkadm5-1.15.1-50.el7.x86_64.rpm 4、 libselinux-devel-2.5-15.el7.x86_64.rpm 5、 libverto-devel-0.2.5-4.el7.x86_64.rpm
libcom_err-devel-1.41.12-22.el6.x86_64.rpm openssl-1.0.1e-58.el6_10.x86_64.rpm libselinux-devel-2.0.94-7.el6.x86_64.rpm openssl-devel-1.0.1e-58.el6_10.x86_64.rpm libsepol-devel-2.0.41-4.el6.x86_64....
Flink Doris Connector 源码(apache-doris-flink-connector-1.13_2.12-1.0.3-incubating-src.tar.gz) Flink Doris Connector Version:1.0.3 Flink Version:1.13 Scala Version:2.12 Apache Doris是一个现代...
CentOS 7.6版本unzip rpm文件。系统为x86-64位的操作系统,文件是rpm文件,可以使用rpm -ivh命令直接安装。
Flink Doris Connector(apache-doris-flink-connector-1.14_2.12-1.0.3-incubating-src.tar.gz) Flink Doris Connector Version:1.0.3 Flink Version:1.14 Scala Version:2.12 Apache Doris是一个现代MPP...
libcom_err-1.42.9-19.el7.x86_64 libmpc-1.0.1-3.el7.x86_64 libselinux-devel-2.5-15.el7.x86_64 libsepol-devel-2.5-10.el7.x86_64 libstdc++-devel-4.4.7-4.el6.x86_64.rpm libverto-devel-0.2.5-4.el7.x86_64 ...
krb5-devel-1.10.3-42.el6.x86_64.rpm,keyutils-libs-devel-1.4-5.el6.x86_64.rpm,libcom_err-devel-1.41.12-22.el6.x86_64.rpm,libselinux-devel-2.0.94-5.8.el6.x86_64.rpm,libsepol-devel-2.0.41-4.el6.x86_...
clickhouse-22.2.2.1-2.rpm离线安装包包含clickhouse-common-static-22.2.2.1-2.x86_64.rpm,clickhouse-client-22.2.2.1-2.noarch.rpm,clickhouse-server-22.2.2.1-2.noarch.rpm共3个离线安装rpm包。...
rpm -ivh libcom_err-devel-1.41.12-23.el6.x86_64.rpm rpm -ivh libkadm5-1.10.3-65.el6.x86_64.rpm rpm -ivh libsepol-devel-2.0.41-4.el6.x86_64.rpm rpm -ivh libselinux-devel-2.0.94-7.el6.x86_64.rpm rpm -...
linux 离线安装gcc++ (简单易懂,已成功安装): autogen-libopts-5.18-5.el7.x86_64.rpm ...libcom_err-1.42.9-11.el7.x86_64.rpm libselinux-devel-2.5-12.el7.x86_64.rpm libsepol-devel-2.5-8.1.el7.x86_64.rpm ...
官方离线安装包,测试可用。使用rpm -ivh [rpm完整包名] 进行安装