# .exp files not deleted with drop database

**URL:** <https://forums.percona.com/t/exp-files-not-deleted-with-drop-database/5502>\
**Category:** General Questions\
**Created:** [March 21, 2017, 4:23pm UTC](https://forums.percona.com/t/exp-files-not-deleted-with-drop-database/5502 "2017-03-21T16:23:57Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ckgurr](https://avatars.discourse-cdn.com/v4/letter/c/9de0a6/32.png) [@ckgurr](https://forums.percona.com/u/ckgurr)\
**Post date:** [March 21, 2017, 4:23pm UTC](https://forums.percona.com/t/exp-files-not-deleted-with-drop-database/5502/1 "2017-03-21T16:23:57Z")

</div>

The .exp file create when a database is backed up with Xtrabackup do not get deleted when the the database is dropped. This causes the error:  
ERROR 1010 (HY000): Error dropping database (can’t rmdir ‘./zfoo/’, errno: 17)

> ls –l /data/mysql/zfoo  
> -rwxrwxr-x 1 mysql mysql 953 Mar 8 16:16 ztest.cfg  
> -rwxrwxr-x 1 mysql mysql 16384 Mar 8 16:16 ztest.exp  
> -rwxrwxr-x 1 mysql mysql 8948 Mar 8 16:15 ztest.frm  
> -rwxrwxr-x 1 mysql mysql 98304 Mar 8 16:01 ztest.ibd

mysql\> drop database zfoo;  
ERROR 1010 (HY000): Error dropping database (can’t rmdir ‘./zfoo/’, errno: 17)

> ls –l /data/mysql/zfoo  
> -rwxrwxr-x 1 mysql mysql 16384 Mar 8 16:16 ztest.exp

Any ideas how to fix this?

---

<div class="post-metadata">

**Author:** ![mirfan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mirfan/32/16890_2.png) [@mirfan](https://forums.percona.com/u/mirfan)\
**Post date:** [April 1, 2017, 2:40am UTC](https://forums.percona.com/t/exp-files-not-deleted-with-drop-database/5502/2 "2017-04-01T02:40:56Z")

</div>

Workaround would be to manually delete zfoo directory.