ERROR 1010 (HY000) at line 1: Error dropping database (can't
Posted: Fri Apr 19, 2013 6:49 pm
Getting the below error when I try to drop the database :
ERROR 1010 (HY000) at line 1: Error dropping database (can't rmdir './roundcube', errno: 39).
Reason : Files might be corrupted
Solution : Rename the directory that contains the corrupted files and then recreate the folder "roundcube" with same permission and ownership
Now try to delete the database again.
ERROR 1010 (HY000) at line 1: Error dropping database (can't rmdir './roundcube', errno: 39).
root@server[/var/lib/mysql]# mysql -e "drop database roundcube";
ERROR 1010 (HY000) at line 1: Error dropping database (can't rmdir './roundcube', errno: 39)
root@server[/var/lib/mysql]#
Reason : Files might be corrupted
Solution : Rename the directory that contains the corrupted files and then recreate the folder "roundcube" with same permission and ownership
Now try to delete the database again.