刚刚发生了一些奇怪的事情,我有一个数据库,我丢弃了整个数据库一次,因为它几乎是凌乱的,之后,我再次创建它并设法找到更多错误,所以我再次删除它但是这一次,查询持续了很长时间,我不得不打断它。 但是每次我打断它,Workbench都会立即崩溃。 之后,我尝试改变表格,但它现在做同样的事情。 我该怎么办?
更新:我现在也不能删除表格。 我认为与架构更改相关的任何内容都会使其永久挂起和加载。 更新:显然,我仍然可以在其他数据库上执行其他正常的数据库操作,但不是我正在处理的那个。 有任何想法吗?
Something weird just happened, I have a database and I dropped the whole DB once since it was practically messy, afterwards, I created it again and managed to find more errors so I dropped it again but this time, the query went on for so long, I had to interrupt it. But every time I interrupt it, Workbench crashes instantly. Afterwhich, I tried altering tables instead but it does the same thing now. What should I do?
Update: I can't drop tables as well now. I think anything related to schema changes makes it hang and load forever. Update: Apparently, I can still perform other normal database operations on other databases just no the one I'm working on though. Any ideas?
最满意答案
你可能完全弄乱了你的架构。 MySQL中的模式/ dbs只是数据目录中的文件夹。 因此,尝试使用损坏的数据库删除文件夹(移动到数据文件夹外的位置),看看是否恢复正常。
You probably messed up your schema entirely. Schemas/dbs in MySQL are just folders in the data directory. So try removing the folder with the corrupt db (move to a place outside the data folder) and see if things go back to normal.
更多推荐
发布评论