I'm baffled as to why this isn't working... I am 'root'. I have full perms and all that stuff. I use these DBs every day. Yesterday, I deleted a table that had FKs because I wanted to change a column name, but couldn't because of the restraint *sigh*. After that I couldn't re-create the table again. So breaking it down to basic level...
mysql> use mydbB; mysql> CREATE TABLE foo ( id int(10) unsigned NOT NULL auto_increment, name varchar(255) NOT NULL, PRIMARY KEY id (id) ); ERROR 3 (HY000): Error writing file './mydbB/foo.frm' (Errcode: 5) mysql> use mydbA; mysql> CREATE TABLE foo ( id int(10) unsigned NOT NULL auto_increment, name varchar(255) NOT NULL, PRIMARY KEY id (id) ); Query OK, 0 rows affected (0.04 sec) [EMAIL PROTECTED]:/var/lib/mysql# ll total 28748 drwxrwxrwx 2 mysql mysql 8192 Nov 16 22:46 mydbA drwxrwxrwx 2 mysql mysql 4096 Nov 16 22:50 mydbB -rw-rw---- 1 mysql mysql 5242880 Nov 16 22:46 ib_logfile0 -rw-rw---- 1 mysql mysql 5242880 Nov 13 22:07 ib_logfile1 -rw-rw---- 1 mysql mysql 18874368 Nov 16 22:46 ibdata1 drwx------ 2 mysql mysql 4096 Nov 13 22:07 mysql drwx------ 2 mysql mysql 4096 Nov 13 22:06 test All drives have gigabytes free. "ENGINE=InnoDB" matters not. What gives? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
