无法删除数据库mysql:错误3664(HY000) [英] Unable to drop database mysql: ERROR 3664 (HY000)

问题描述

我的应用程序中有一个名为X-Files的数据库.

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

我要drop它.但是每当我运行命令drop database 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'.

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

我还没有找到关于此错误的任何参考.另外，我已经检查了我的sql服务器是否已启动并正在运行.

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

推荐答案

尝试在SystemPreferences/MySQL下手动启动数据库.我遇到了同样的问题，并且忘记了取消选中启动计算机后自动启动sql的选项.重新初始化数据库后，一切都按预期开始工作.

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.

这篇关于无法删除数据库mysql:错误3664(HY000)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！