mysql database 삭제 불가시...

MySQL: ERROR 1010 (HY000): Error dropping database (can't rmdir './데이터베이스명', errno: 39)

위와 같은 에러로 database 삭제가 불가한 경우 아래 방법데로 하면 삭제됨.

The solution
# cd /var/lib/mysql --> mysql 설치시 db 저장 경로임.
var/lib/mysql# ls
foodb
/var/lib/mysql# rm -fr foodb
mysql> drop database foodb;
ERROR 1008 (HY000): Can't drop database 'foodb'; database doesn't exist
mysql> create database foodb;
Query OK, 1 row affected (0.00 sec)
mysql> drop database foodb;
Query OK, 0 rows affected (3.38 sec)

 

출처 : http://micharg.blogspot.com/2011/05/mysql-error-1010-hy000-error-dropping.html