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 | > +----------+ > 2 rows in set (0.00 sec) > > mysql> use mis; > Database changed > > mysql> show tables; > Empty set (0.00 sec) > > I was logged in as mysql's root user at the time, and had successfully > deleted other databases. I also tried dropping the database with > 'mysqladmin', which likewise told me the database had been dropped, but > didn't actually drop it. > > The solution I used was to stop mysqld and then rm the database from the > filesystem. > > I'm using mysql version 3.23.58 on redhat 7.3. > > Apologies if this has been discussed before, but I couldn't find a > reference to it in the archive. Elsewhere, I found that someone else > has seen this problem[1], but found no answer. > > If anyone can give any hints as to what I should've done, or what went > might've gone wrong at the time, I'd be grateful. >
Are there any non-mysql files in the directory of the database 'mis'? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
