ERROR 1010 (HY000): Error dropping database (can't rmdir './lighter/', errno: 17)

If you tell mysql to `drop database lighter;` and it tells you:

ERROR 1010 (HY000): Error dropping database (can't rmdir './m/', errno: 17)

Then make sure /var/lib/mysql/lighter (or wherever) is empty :)



Also, does anyone know how to mysqldump UTF8 data without it fux0ring 
the encoding on all the varchar columns? Blobs work fine, but no matter what I
specify for --default-character-encoding it still pukes.

`SELECT INTO 'file'...` + `LOAD DATA INFILE 'file'...` works because it doesn't 
try to get smart and interpret the data: just spews binary. But mysqldump is
so much more convenient...

Comments

[Eric Jessup]

[this is good] Hi, i must say fantastic site you have, i stumbled across it in Google. Does you get much traffic?

[Jedidiah Blalock]

[this is good] Not in it business.

[Alex Krenvalk]

To solving such problem out you need to prof recovery software.
I would recommend you following software http://www.mysql.fixtoolbox.com