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.
Can't drop database
Moderator: General Moderators
- dibyendrah
- Forum Contributor
- Posts: 491
- Joined: Wed Oct 19, 2005 5:14 am
- Location: Nepal
- Contact:
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 and in windows it's usually where the mysql is installed
Dibyendra
Code: Select all
/var/lib/mysqlCode: Select all
/path/to/mysql/dataDibyendra