刚刚发生了一些奇怪的事情，我有一个数据库，我丢弃了整个数据库一次，因为它几乎是凌乱的，之后，我再次创建它并设法找到更多错误，所以我再次删除它但是这一次，查询持续了很长时间，我不得不打断它。 但是每次我打断它，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.
更多推荐
发布评论