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


Материал из Wiki - Iphoster - 'the best ever support'

Перейти к: навигация, поиск


# 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.


Индекс цитирования