MySQL error when deleting database (errno:39)

Because the MySQL database is the default case-sensitive, the deployment of the time to find a number of duplicate tables, so the redundant table deleted. However, the remaining duplicate tables are then deleted with a hint: The table does not exist.

So, want to delete the database to recreate, but, got the error 1010 (HY000): Error dropping database (can ' t rmdir './tablename ', errno:39) such a mistake.

Workaround : Delete all files under/var/lib/mysql/tablename and do not delete the tablename itself. You can then drop the database from the command line.

MySQL error when deleting database (errno:39)