$ perror 5 OS error code 5: Input/output error How did you delete the table?
On Nov 17, 2007 7:03 AM, Daevid Vincent <[EMAIL PROTECTED]> wrote: > 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] > > -- Regards, Ady Wicaksono Email: ady.wicaksono at gmail.com http://adywicaksono.wordpress.com/
