I'm putting this back on the list where it belongs; that enables everyone to
help and to learn from the discussion, either now or in the future via the
list archive.
--
Ahh, so you've tried to re-create the database after it appeared to be
safely dropped! You didn't say that in your note so I wanted to be sure you
had done that much before writing the note.
Have you looked in the MySQL log to see if it is reporting any problems with
the DROP? If you are using INNODB, have you tried a SHOW STATUS INNODB to
see if it reported any problems?
--
Rhino
----- Original Message -----
From: "Randy Paries" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>
Sent: Saturday, April 22, 2006 11:04 AM
Subject: Re: please help, can not delete database
when i go back and try to create it , it says it already exisit?
Randy
On 4/22/06, Rhino <[EMAIL PROTECTED]> wrote:
What makes you think the delete of the database failed? It looks like the
message from the DROP command indicates that the database was dropped
successfully.
--
Rhino
----- Original Message -----
From: "Randy Paries" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Saturday, April 22, 2006 9:22 AM
Subject: please help, can not delete database
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.385 / Virus Database: 268.4.5/321 - Release Date: 21/04/2006
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.385 / Virus Database: 268.4.5/321 - Release Date: 21/04/2006
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.385 / Virus Database: 268.4.5/321 - Release Date: 21/04/2006
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.385 / Virus Database: 268.4.5/321 - Release Date: 21/04/2006
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
