ERROR 1010 (HY000): Error dropping database (can & #39; t rmdir & #39;. \ test \ & #39;, errno: 17), hy000errno

Source: Internet
Author: User

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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.