Packets larger than max_allowed_packet are not allowed”

颜子 2012-07-27 04:58:45

我是新手，做了一个excel的文档保存数据库的操作，由于文件量较大，结果就出现Packets larger than max_allowed_packet are not allowed” 错误。我有百度搜了下解决方案，
看到wpekin的博客里的解决方案如下：

MySQL的一个系统参数：max_allowed_packet，其默认值为1048576(1M)，
查询：show VARIABLES like '%max_allowed_packet%';
修改此变量的值：MySQL安装目录下的my.ini文件中的[mysqld]段中的＂max_allowed_packet = 1M＂，如更改为4M(如果没有这行内容，增加一行)，保存，重起MySQL服务。现在可以load大于1M的文件了

我按照那样做了，但是还是会出现一样的错误；求高手指导；（谁能提供个.NET群么？到时可以方便请教各位高手，我是新手）

...全文

198 回复打赏收藏转发到动态举报

写回复

回复

切换为时间正序

请发表友善的回复…

发表回复

{ datetime.inc}{ version.inc}const helplines=120;helpdata:array[1..helplines] of pchar=(‘RealMedia Analyzer, Version ‘+Version+‘ build ‘+_DATETIME_,‘Copyleft (C) 2000-2003 Virtual Research‘,‘‘,‘Usage: rma [command] ‘,‘‘,‘Command must start with a hyphen.‘,‘All commands and arguments are case-sensitive.‘,‘Available commands are:‘,‘‘,‘ -c[arguments] = check file integrity (default)‘,‘ arguments:‘,‘ d = set maximum allowed timestamp difference to n (0..32767)‘,‘ milliseconds, 0 means don‘‘t care, default is 2000‘,‘ s = set maximum allowed packet size to n (1..32767) kilobytes,‘,‘ default is don‘‘t care‘,‘ t = disable timestamps checking‘,‘ v = lower verbosity level (disable packets counter)‘,‘ z = stop on timestamp errors‘,‘‘,‘ -f[arguments] = try to fix broken file‘,‘ arguments:‘,‘ a = exclude n (0..64) packets after first found intact packet‘,‘ (but not more than the number used with ‘‘c‘‘ argument),‘,‘ default is 0‘,‘ b = exclude n (0..64) packets before last intact packet, default is 0‘,‘ c = use minimal size of n (2..32767) packets chain when searching for‘,‘ unbroken stream parts, default is 4‘,‘ d = set maximum allowed timestamp difference to n (0..32767)‘,‘ milliseconds, 0 means don‘‘t care, default is 2000‘,‘ m[suppresion level] = suppress logging, 1 means do not update log,‘,‘ 2 means mark only, 3 means suppress completely (default)‘,‘ n = only fix n (1..32767) broken packets, default is all‘,‘ p = force maximum packet size (intact packet criterion) to‘,‘ n (16..32767) bytes, default is take from header‘,‘ s = set maximum allowed packet size (broken packet criterion) to‘,‘ n (1..32767) kilobytes, default is don‘‘t care‘,‘ t = disable timestamps checking‘,‘ v = lower verbosity level (disable packets counter)‘,‘ z = try to fix timestamp errors‘,{ __UNIX__}‘ undo filename = create an undo file with the specified pathname‘,{}‘ /undo filename/ = create an undo file with the specified pathname‘,{}‘‘,‘ -d[argument] = dump some information about the file‘,‘ arguments (mutually exclusive):‘,‘ b = dump brief information about the file‘,‘ g = dump general information (default)‘,‘ l = display operations log only‘,‘ i = dump file index‘,‘‘,‘ -i[arguments] = rebuild index sections‘,‘ arguments:‘,‘ a = index all keyframe packets‘,‘ m[suppression level] = suppress logging‘,‘ v = lower verbosity level (disable packets counter)‘,‘‘,‘ -j[arguments] = join (multiplex) two RealMedia streams‘,‘ arguments:‘,{ __UNIX__}‘ firstfilename = pathname of the file containing first stream,‘,‘ default is stream00.rm‘,‘ secondfilename = pathname of the file containing second stream,‘,‘ default is stream01.rm‘,{}‘ /firstfilename/ = pathname of the file containing first stream,‘,‘ default is stream00.rm‘,‘ /secondfilename/ = pathname of the file containing second stream,‘,‘ default is stream01.rm‘,{}‘ i = build index after join‘,‘ m[suppression level] = suppress logging‘,‘ o = write old-style file header‘,‘ p = paste instead of multiplex‘,‘ s = try to synchronize streams‘,‘ q[l] = set relative stream 0 to stream 1 skew in milliseconds‘,‘ (0..10000, signed). ql means set logical skew,‘,‘ otherwise set physical skew‘,‘ v = lower verbosity level (disable packets counter)‘,‘‘,‘ -l = strip operations log and RealMedia Analyzer mark, if any‘,‘‘,‘ -p = display RealMedia Analyzer use and (re)distribution policy‘,‘‘,‘ -s[arguments] = split (demultiplex) stream‘,‘ arguments:‘,‘ m[suppression level] = suppress logging‘,‘ o = write old-style file header‘,{ __UNIX__}‘ p = use specified drive/directory for output files‘,‘ (default is current directory)‘,{}‘ p = use specified drive/directory for output files‘,‘ (default is current directory)‘,{}‘ x = extract n‘‘th stream from the file‘,‘ v = lower verbosity level (disable packets counter)‘,‘‘,‘ -u[arguments] = discard changes according to specified undo file‘,‘ (in this case, is the undo file pathname)‘,‘ arguments:‘,‘ m[suppression level] = suppress logging‘,‘‘,‘ -x[arguments] = extract part of stream‘,‘ (this command only works with the single-stream files)‘,‘ arguments:‘,‘ / (default is 00:00:00.00)‘,‘ (default is end of stream)‘,‘ d = delete part of stream instead of extract‘,‘ k = ignore keyframes‘,‘ m[suppression level] = suppress logging‘,‘ o = write old-style file header‘,{ __UNIX__}‘ p = use specified drive/directory for output file‘,‘ (default is current directory)‘,{}‘ p = use specified drive/directory for output file‘,‘ (default is current directory)‘,{}‘ t = ignore timestamps‘,‘‘,‘examples:‘,‘‘,‘ rma test.rm‘,‘ check integrity of test.rm‘,‘‘,‘ rma -f test.rm‘,‘ try to fix errors in test.rm with default settings‘,‘‘,‘ rma -fb2n1 test.rm‘,‘ try to fix errors in test.rm, seek two packets back‘,‘ when broken packet is found, only fix first broken packet‘,‘‘,‘ rma -sx1 test.rm‘,‘ extract stream 1 from test.rm‘,‘‘,{ __UNIX__}‘ rma -jaudio.rmvideo.rm test.rm‘,{}‘ rma -j/audio.rm//video.rm/ test.rm‘,{}‘ join streams from audio.rm and video.rm and write‘,‘ multiplexed stream to test.rm.‘,‘‘);

转载于 https://blog.csdn.net/gtosky4u/article/details/8581281. 向 mysql 的 mediumblob类型的变量写入数据时，该变量限制大小为4M，写入数据3M，结果报错：Packets larger than max_allowed_packet are not allowed。原因：mysql 限制了输入的大小解决方法：在 Navicat 中进入查询界面，输入 set global max_allowed_packet = 2*1024*

MySQL报错packets larger than max_allowed_packet are not allowed MySQL报错packets larger than max_allowed_packet are not allowed MySQL根据配置文件会限制Server接受的数据包大小。有时候大的插入和更新会受 max_allowed_packet 参数限制,导致写入或者更新失败修复方法： 1.修改配置文件my.ini max_allowed_packet = 10M 2.使用命令修改

MySQL Packets larger than max_allowed_packet are not allowed MySQL的一个系统参数：max_allowed_packet，其默认值为1048576(1M)，查询：show VARIABLES like '%max_allowed_packet%'; 修改此变量的值：MySQL安装目录下的my.ini文件中的[mys...

在导大容量数据特别是CLOB数据时，可能会出现异常：“Packets larger than max_allowed_packet are not allowed”。这是由于MySQL数据库有一个系统参数max_allowed_packet，其默认值为1048576(1M) 可以通过如下语句在数据库中查询其值： show VARIABLES like '%max_allowed_packe...

110,525

社区成员

642,571

社区内容

发帖

与我相关

我的任务

社区管理员

加入社区

近7日
近30日
至今

加载中

查看更多榜单

社区公告

让您成为最强悍的C#开发者

试试用AI创作助手写篇文章吧

+ 用AI写文章