* check on your filesystem if the directory actually still exists - rmdir on a nonexisting dir might throw a non-zero exit * Take your db offline and do an fsck. If you want, you could flush tables with read lock, then mount -oremount,ro and then fsck - that'll keep your db up for reads, at least. DON'T let fsck fix things that way, though - for that you really do need to shut down the db and unmount the disk.
On Fri, Jan 30, 2009 at 7:29 PM, Claudio Nanni <claudio.na...@gmail.com>wrote: > I am banging my head. > > First, is not a file permission problem. > > I cant import data on some replication slaves either in binary, or from a > sql mysqldump. > > I use one innodb file per table and I am importing only two databases on a > dozen. > > After a few hours seem that the problem is with the name of the database, > > since I can import on a different database/directory. > > I tried to import only the DDL(from the master where the dump comes from) > > to recreate all the tables to 'refresh' the information schema, > > then stop the DB, copy the .ibd datafiles in the directory, start the DB, > > and if I do a DESC dummy get: > > > ------------------------------------------------------------------------------------------- > > ERROR 1146 (42S02): Table 'foobar.dummy' doesn't exist > > > ------------------------------------------------------------------------------------------- > > If I drop the database I get the error in the subject > > > --------------------------------------------------------------------------------------- > > ERROR 1010 (HY000): Error dropping database (can't rmdir ./foobar > > > --------------------------------------------------------------------------------------- > > If I try to import from the SQL dump: > > > --------------------------------------------------------------------------------------- > > ERROR 1005 (HY000) at line 23: Can't create table './foobar/dummy.frm' > (errno: -1) > > > --------------------------------------------------------------------------------------- > > I am stuck, any help really really aprreciated! > > Cheers > > Claudio > -- Celsius is based on water temperature. Fahrenheit is based on alcohol temperature. Ergo, Fahrenheit is better than Celsius. QED.
