Forcing a DB Drop

------=_Part_11070_15550655.1160045079582
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi,
I am running mysql 5.0.15-nt on winXP. I have a database with default
character set utf8 and some tables which are mostly empty. I want to drop
this database, but whenever I try that, mysql server crashes. Even trying to
drop a table in this DB crashes. I tried creating and deleting another
database with same tables and I am able to drop that.

How to I force delete this database so that I can create it again?

Thanks
Sanjay Goel
http://sanjaygoel.blogspot.com

------=_Part_11070_15550655.1160045079582--
Sanjay Goel [ Do, 05 Oktober 2006 12:44 ] [ ID #1489822 ]

RE: Forcing a DB Drop

>
>How to I force delete this database so that I can create it again?
>
If it's MyISAM, simply stop the server, and delete the folder in the =
data dir, and start the server again.
(you have a folder for each database)
Hint: Do NOT delete the \mysql\ folder!!!


I have no idea if the database is InnoDB!!!


/jesper H

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32 [at] m.gmane.org
JHN [ Do, 05 Oktober 2006 14:01 ] [ ID #1489823 ]
Datenbanken » gmane.comp.db.mysql.windows » Forcing a DB Drop

Vorheriges Thema: Table name problem
Nächstes Thema: table_cache not registering