Create table returns error Can't create table './Identity/Roles.frm, however it does create Roles.ibd file.
CREATE TABLE IF NOT EXISTS `Roles` (`role` VARCHAR(25) NOT NULL , PRIMARY KEY (`role`) ) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8
I can create table using MyISAM but not innodb. I also tryed to copy frm+ibd files from another schema (same table another schema). Show tables shown Roles correctly but check table gives error Can't find file: './Identity/Roles.frm' (errno: 13). Drop table gives error ERROR 1051 (42S02): Unknown table 'Roles'.
Manualy deleting files doesn't help either as create table fails again, creating Roles.ibd only.
Same create query runs in another schema without problems.
MySql version: 5.0.83-log Gentoo Linux mysql-5.0.83
Any ideas whats going on? Thanks