Re: 'drop database' failing silently? - solved.

2004-05-05 Thread Kevin O' Riordan
> > this morning, I had a problem dropping a database from within mysql. [snip] > > The solution I used was to stop mysqld and then rm the database from the > > filesystem. > Are there any non-mysql files in the directory of the database 'mis'? After a while, I realised you weren't asking a ques

Re: 'drop database' failing silently?

2004-05-05 Thread Kevin O' Riordan
> > this morning, I had a problem dropping a database from within mysql. > Are there any non-mysql files in the directory of the database 'mis'? Should've added this. There was only one file in the 'mis' directory: -rw-rw-rw-1 mysqlmysql 44 Apr 30 09:51 file.out Which con

Re: 'drop database' failing silently?

2004-05-05 Thread Victoria Reznichenko
Kevin O' Riordan <[EMAIL PROTECTED]> wrote: > this morning, I had a problem dropping a database from within mysql. > >mysql> drop database mis; >Query OK, 0 rows affected (0.00 sec) > >mysql> show databases; >+--+ >| Database | >+--+ >| mis | >

'drop database' failing silently?

2004-05-05 Thread Kevin O' Riordan
Hi all, this morning, I had a problem dropping a database from within mysql. mysql> drop database mis; Query OK, 0 rows affected (0.00 sec) mysql> show databases; +--+ | Database | +--+ | mis | | mysql| +--+ 2 rows in