how to drop database

mysql database-administration
devang picture devang · Jan 12, 2010 · Viewed 51.6k times · Source

i used the following sytanx 

drop database filmo;

and got the following error:

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

any ideas..

Answer

tanerkay picture tanerkay · Jan 12, 2010

It means there are files in that directory not relating to MySQL. Another issue, although I doubt it, is insufficient permissions. You may delete that directory from the filesystem.

Related questions

improve speed of mysql import

I have large database of 22GB. I used to take backup with mysqldump command in a gzip format. When i extract the gz file it produces the .sql file of 16.2GB When I try to import the database in my …

Read More
mysql_secure_installation "Can't connect to local MySQL server through socket"

When I am invoking the file mysql_secure_installation I get an error like [mysqk123@InstallZeMo bin]$ ./mysql_secure_installation NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP …

Read More
how to drop partition without dropping data in MySQL?

I have a table like: create table registrations( id int not null auto_increment primary key, name varchar(50), mobile_number varchar(13)) engine=innodb partition by range(id) ( partition p0 values less than (10000), partition p0 values less than (20000), partition p0 values …

Read More