MySQL - ERROR 1005 (HY000) at line xx: Can't create table 'admin 1.wp comments' (errno: -1)

Материал из Wiki - Iphoster - the best ever hosting and support. 2005 - 2024
Перейти к:навигация, поиск

# mysql -u admin_1 -p admin_1 < backup.sql
Enter password:
ERROR 1005 (HY000) at line 52: Can't create table 'admin_1.wp_comments' (errno: -1)


Posted by Burt Culver on August 18, 2008
I was blocked creating a InnoDB table in a import of a mysqldump and found a way to resolve the 1005 error with errno: -1 - delete the tablename.ibd file. Then the table create works fine.