mysql导入数据库报错ERROR 1005 xxxxxx (errno: -1)
导入数据库出现下面提示错误：ERROR 1005 (HY000) at line 1727: Can't create table 'xxxxxxx' (errno: -1)查看日志会有以下报错：120912 20:24:42 InnoDB: Error creating file './xxxxxx.ibd'.120912 20:24:42 InnoDB: Operating system error number 17 in a file operation.InnoDB: Error number 17 means 'File exists'.InnoDB: Some operating system error numbers are described atInnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.htmlInnoDB: The file already exists though the corresponding table did notInnoDB: exist in the InnoDB data dictionary. Have you moved InnoDBInnoDB: .ibd files around without using the SQL commandsInnoDB: DISCARD TABLESPACE and IMPORT TABLESPACE, or didInnoDB: mysqld crash in the middle of CREATE TABLE? You canInnoDB: resolve the problem by removing the file './xxxxxxxxx.ibd'InnoDB: under the 'datadir' of MySQL?从报错日志可以看到解决方法：InnoDB: resolve the problem by removing the file './xxxxxxx.ibd'所以只要移除'./xxxxxxxx.ibd'这个文件即可
