Wednesday, January 21, 2015

MySQL: ERROR 1010 (HY000): Error dropping database (can't rmdir './suhail', errno: 39)

The problem 
==========
mysql> drop database suhail;
ERROR 1010 (HY000): Error dropping database (can't rmdir './suhail', errno: 39)

The solution
==========
# cd /var/lib/mysql 
var/lib/mysql# ls
suhail
/var/lib/mysql# rm -fr suhail
mysql> drop database suhail;
ERROR 1008 (HY000): Can't drop database 'suhail'; database doesn't exist
mysql> create database suhail;
Query OK, 1 row affected (0.00 sec)
mysql> drop database suhail;
Query OK, 0 rows affected (3.38 sec)

No comments:

Post a Comment