Can't drop database

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
bwv2
Forum Commoner
Posts: 83
Joined: Fri Jun 10, 2005 11:50 am
Location: AZ

Can't drop database

Post 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.
User avatar
dibyendrah
Forum Contributor
Posts: 491
Joined: Wed Oct 19, 2005 5:14 am
Location: Nepal
Contact:

Post 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:
Post Reply