Search code examples
mysqldatabasewindowsarchive

Dropping MySQL Archive Databases

I have MySQL 5.0 running on a Windows 2003 server. I was trying to drop an archive database when I received this error:

Error dropping database (can't rmdir './database_name/', errno: 17)

There are ARM and ARN files in every directory for every archive database on the server. From what I can tell, these are generated during an optimize.

Is it safe to remove these files manually so that a drop command in mysql will go through normally?

Solution

  • It could mean for example - database directory contains some files that is not belongs to mysql database. For instance .empty file.