今天备份数据总是提示 mysqldump: Error 1317: mysqldump: Error 1317: Query execution was interrupted when dumping table `786_art` at row: 5005 本想备份数据导入另一个服务器的 可是总是出现这个错误。求解。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 检查一下 `786_art`表中5005行记录的内容 是什么 每次备份都是不同行的错误提示[root@new 67786.com]# mysqldump -h localhost -u c67786 -p c67786 >1.sqlEnter password:mysqldump: Error 1317: Query execution was interrupted when dumping table `786_art` at row: 52679[root@new 67786.com]# mysqldump -h localhost -u c67786 -p c67786 >1.sqlEnter password:mysqldump: Error 1317: Query execution was interrupted when dumping table `786_art` at row: 96465[root@new 67786.com]# mysqldump -h localhost -u c67786 -p c67786 >1.sqlEnter password:mysqldump: Error 1317: Query execution was interrupted when dumping table `786_art` at row: 57901[root@new 67786.com]# mysqldump -h localhost -u c67786 -p c67786 >1.sqlEnter password:mysqldump: Error 1317: Query execution was interrupted when dumping table `786_art` at row: 61770 什么 系统、磁盘什么格式(NTFS)? 配置文件中增加此参数值的大小试下max_allowed_packetor升级MYSQL试试 java连接Mysql数据库没有提示错误,但控制台中出现大量英文提示,请问是什么原因 关于insert语句的兼容问题 postgresql返回数据集取不到数是怎么回事啊 这个sql应该怎么改 mysql数据库编码问题,全显示问号???????? 我的mysql数据库怎么突然起动不了了? 数据库排序问题 mysql出错。mysql-front,另附一问 对MYSQL进行LOAD DATA INFILE '' INTO DATABASE能否在客户端程序中处理? 触发器相关 请给个例子 谢谢 mysql外键约束 mysql导入.sql文件
[root@new 67786.com]# mysqldump -h localhost -u c67786 -p c67786 >1.sql
Enter password:
mysqldump: Error 1317: Query execution was interrupted when dumping table `786_art` at row: 52679
[root@new 67786.com]# mysqldump -h localhost -u c67786 -p c67786 >1.sql
Enter password:
mysqldump: Error 1317: Query execution was interrupted when dumping table `786_art` at row: 96465
[root@new 67786.com]# mysqldump -h localhost -u c67786 -p c67786 >1.sql
Enter password:
mysqldump: Error 1317: Query execution was interrupted when dumping table `786_art` at row: 57901
[root@new 67786.com]# mysqldump -h localhost -u c67786 -p c67786 >1.sqlEnter password:
mysqldump: Error 1317: Query execution was interrupted when dumping table `786_art` at row: 61770
max_allowed_packetor升级MYSQL试试