ERROR 1010 (HY000): Error dropping database (can't rmdir '. \ test \', errno: 17), hy000errno
Mysql5.5.40 has been deployed in the production system. Due to development requirements, dump the data in the production database and import it to the test environment created by the development!
After the test is completed, delete the temporary data as needed,
Delete database directly
Mysql> drop database test;
ERROR: Error 1010 (HY000): ERROR dropping database (can't rmdir '. \ test \', errno: 17)
Go to the database and check whether the data object has been deleted. What is the error message?
After the suspect is a bug, I found the mysql bug on the Mysql official website and confirmed it based on the version number. The development database is 5.5.20, which is not very consistent with the bug;
However, you can refer to the solutions provided by the bug.
Go to the database data directory, delete the content in the test file, and run the DELETE command again. A message is displayed, indicating that the database does not exist!
Note: No error is reported for the same operation on 5.5.40, but an error is reported on the developed 5.5.20. The bug is defined as 5.5.20.