今天备份数据总是提示 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试试 用mysql做数据库设计的时候,你们关注过tinyint和int的区别么? 请看我的sql 最后用orderby排序居然无效 求解 急!!! mysql 备份数据库 MySql 登录失败 (Error No.1045) MySQL Workbench 5.2 CE无法启动 为什么我存在mysql中的某一列的值全是MEMO 急!急!急!Can't open file: 'lfj_artic.MYI'.哪位大哥帮助解决一下 mysql难道不支持嵌套查询? 请问没有相同条件,能否将两个表的数据链到一起呢?!(join) SQL left join 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试试