Page 1 of 1

Can't drop database

Posted: Mon May 01, 2006 12:21 am
by bwv2
I used phpMyAdmin to run the following statement:

DROP DATABASE `renewabledb`

It deleted all tables from the db, but didn't delete the db. I got the following error:

#1051 - Unknown table '#sql-d90_7a,#sql-d90_7b,#sql-d90_7c'

Any ideas what I should do? Any help would be appreciated.

Posted: Mon May 01, 2006 3:49 am
by dibyendrah
Are the tables using InnoDB engine ? Might be table is corrupted . You can delete database manually by deleting the database folder under data which mysql uses to store database . In linux the path is usually

Code: Select all

/var/lib/mysql
and in windows it's usually where the mysql is installed

Code: Select all

/path/to/mysql/data

Dibyendra :wink: