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 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.
thanks in advance,
-kev
[1]
http://forums.devarticles.com/showthread.php?s=d1026b7f0c6df0f6f105248888dafb23&p=30160#post30160
--
<jc> never send a butcher to the comms room
Timeless wisdom from JC, on #supporteers (irc.linux.ie)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]