Recently drop database pai; Error
Error 1010 (HY000): Error dropping database (can ' t rmdir './pai ', errno:39)
I just want to remove the library file and try it, so
Rm-rf/usr/local/mysql/data/pai
then I show databases;
And then there's the PAI library.
So drop database pai;
Error 1010 (HY000): Error dropping database (can ' t rmdir './pai ', errno:39)
Tangled for a long time, most of the online is not deleted Pai, but the inside of the file. I've deleted the library.
So mysql> show variables like '%datadir% ';
+---------------+-----------------+
| variable_name | Value |
+---------------+-----------------+
| DataDir | /var/lib/mysql/|
+---------------+-----------------+
We found Pai in this directory.
So Rm-rf/var/lib/mysql/pai
then show databases;
The result is gone and is deleted.
This article is from the "domineering full" blog, please be sure to keep this source http://8813745.blog.51cto.com/8803745/1535856