Randy Paries wrote:
Hello,
Not sure what is going on
i have mysql Ver 12.22 Distrib 4.0.17,
I have a database that i can not delete.
i do this
#mysqladmin drop billmax -u admin --password
Enter password:
Dropping the database is potentially a very bad thing to do.
Any data stored in the database will be destroyed.
Do you really want to drop the 'billmax' database [y/N] y
Database "billmax" dropped
But it does not do anything.
I have tried restarting the DB and restarting the box as well
Please help
Randy
Remember that MySQL uses directories to implement databases. When you
drop a database, it deletes the table files and then tries to delete the
directory. If the directory remains, even if it is empty, it still looks
like a databbase to MySQL.
So check the directory that corresponds to this troublesome database for
unusual permissions or content (such as some files other than MySQL's
table files) that may be preventing the deletion of the directory.
(Check /etc/my.cnf for the location of your database directories. RedHat
usually puts them in /var/lib/mysql.)
Let us know if that was the problem.
--John
PS Remember to reply to the list :)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
