数据导入错误.如何解决?急!!!!!!!!

从本地恢复数据 - 检查数据文件:

数据文件 forumdata/0206_i0NqVPQJ-11.sql 存在检查 ... 成功

数据文件 forumdata/0206_i0NqVPQJ-11.sql 可读检查 ... 成功

从本地读取数据 ... 成功

数据文件 forumdata/0206_i0NqVPQJ-11.sql 格式检查 ... 成功

拆分操作语句 ... 成功

正在恢复数据,请等待 ...


Discuz! info: MySQL Query Error

Time: 2007-2-8 1:58pm
Script: /bbs/restore.php

SQL: INSERT INTO cdb_posts VALUES ('20201','19','2361','0','当不负卿','153','','1153584300','偶与丫头是有缘无分，\r\n偶是积极的向她靠近，\r\n恰如竹篮打水空费力，\r\n也请小雪给偶来分析。','58.63.183.224','0','0','1','0','-1','-1','0','0','0','0'), ('20202','19','2361','0','当不负卿','153','','1153584462','呵呵，调侃的，\r\n网友不要误会，\r\n丫头比较爽朗，\r\n是个明白的人。','58.63.183.224','0','0','1','0','-1','-1','0','0','0','0'), ('21106','10','3261','0','亡命天涯','9','','1154103797','俺们84吵架~~~俺们是杠杠的铁哥们~~~俺们讨论问题来着~~~','60.24.131.210','0','0','1','0','-1','-1','0','0','0','0'), ('20248','16','3116','1','一颗尘土','137','恋师情节你有过吗？','1153660241','恋师情节你有过吗？\r\n 我有过的，我喜欢过我们当时的政治老师，喜欢上他的课，喜欢他的声音，喜欢他


Error: Duplicate entry '20201' for key 1
Errno.: 1062


如果用后台恢复备份提示错误为:
Discuz! info: MySQL Query Error

User: admin
Time: 2007-2-8 10:02pm
Script: /bbs/admincp.php

SQL: INSERT INTO cdb_posts VALUES ('24326','10','3295','0','晓俊','405','','1155046781','呵呵呵呵','222.82.137.223','0','0','1','0','-1','-1','0','0','0','0'), ('24328','19','3509','0','关·山·月','691','哈哈','1155047512','

原帖由 冷艳傲玫 于 2006-8-7 14:48 发表\r\n\r\n呵呵,你们俩不是一般关系呀!!!

\r\n\r\n别这么说，会引起重大误解的！\r\n哈哈','218.79.83.104','0','0','1','0','0','-1','0','0','0','0'), ('24329','19','3509','0','关·山·月','691','','1155047766','

原帖由 flyingpig 于 2006-8-7 13:46 发表\r\n一看就看到个有点伤感的帖子~~~\r\n看时心动，看后无语······\r\n回家后自己再慢慢伤感吧：（

\r\n\r\n父母深情，无以回报\r\n作为儿女，情何以堪？\r\n\r\n马上十年事，\r\n故乡二老忧\r\n都上心头','218.79.83.104'

1','0','0','0','0'), ('24645','10','3415','0','唯雪','496','','1155134951','呵呵~','61.171.148.180','0','0','0','0','-1','-1','0','0','0','0');
Error: Got a packet bigger than 'max_allowed_packet' bytes
Errno.: 1153

[ 本帖最后由 胡说侃人 于 2007-2-9 20:26 编辑 ]

字段值重复导致无法导入数据，你从哪里备份出来的数据呢？

全部备份的啊

用EditPlus 把备份里的那一句删除，重新导入试试