扶凯

转载本站文章请注明，转载自：扶凯[http://www.php-oa.com]

本文链接: http://www.php-oa.com/2009/03/20/duplicate-entry-for-key-2.html

朋友的一个服务器,用的IDC的机器,备份就一个400多M的sql文件,phpmyadim没法恢复,然后他的服务器跑的IIS加php-cgi动不动就超时.然后mysql在我本地导入时也老出下面的这样的错.

ERROR 1062 (23000) at line 1262: Duplicate entry ‘?�ꡣ�H�o’ for key 2

然后就中止了.NND这家伙吃软不吃硬。来硬的。。 –force。强行导入。不退出

# mysql -u root -p fukai –force < dmc010003_db.myisam.sql
Enter password:
ERROR 1062 (23000) at line 1262: Duplicate entry ‘?�ꡣ�H�o’ for key 2
ERROR 1062 (23000) at line 1263: Duplicate entry ‘m?oʙ�H�m’ for key 2
ERROR 1062 (23000) at line 1271: Duplicate entry ‘?���^��΢Ц’ for key 2
ERROR 1062 (23000) at line 5182: Duplicate entry ‘?�ꡣ�H�o’ for key 2
ERROR 1062 (23000) at line 5187: Duplicate entry ‘?���^��΢Ц’ for key 2
ERROR 1231 (42000) at line 7268: Variable ‘sql_mode’ can’t be set to the value of ‘NULL’

好了，出完几个错，导入成功。