CODEWITHSUNDEEP
mysqldatabase
Rahul
Rahul

Reputation: 5834

Unable to drop database mysql: ERROR 3664 (HY000)

I have a database in my application named X-Files.

I want to drop it. But whenever I run the command drop database X-Files I am getting following error:

mysql> drop database X-Files; ERROR 3664 (HY000): Failed to set SDI 'X-Files.MembersTbl' in tablespace 'x-files/memberstbl'.

I haven't found any reference for this error yet. Also I have checked my sql server is up and running.

Upvotes: 3

Views: 2650

Answers (1)

Misaiah
Misaiah

Reputation: 21

Try to manually start your database under SystemPreferences/MySQL. I had the same issue and forgot I had unchecked the option to automatically start sql upon booting up my computer. After reinitializing the database everything began to work as expected.

Upvotes: 2

Related Questions