'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

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 | | mysql

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

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 question,