MySQL phpMyAdmin 错误 1932 - 引擎中不存在表
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/44897427/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
phpMyAdmin error 1932 - table doesn't exist in engine
提问by qadenza
windows 7 - xampp
Windows 7 - xampp
I have a database with 14 tables. I worked this days with all of them without problems untill this morning.
我有一个包含 14 个表的数据库。这几天我和他们所有人一起工作，直到今天早上都没有问题。
All tables are ok except table posts. When I click on it's name (left menu in phpMyAdmin) I got a message:
除了 table ，所有桌子都可以posts。当我单击它的名称（phpMyAdmin 中的左侧菜单）时，我收到一条消息：
#1932... posts doesnt exist in engine
#1932... posts doesnt exist in engine
On stackoverflow there are six posts with simmilar title, but there is no solution for me.
在 stackoverflow 上有 6 个帖子具有类似的标题，但对我来说没有解决方案。
For example thisis about a system table phpmyadmin.pmaand on ubuntu. I'm on windows and table postsis a user table.
例如，这是关于系统表phpmyadmin.pma和 ubuntu。我在 Windows 上，表posts是用户表。
Any help?
有什么帮助吗？
回答by Kennedy Maikuma
This worked for me when I was not able to repair the table
当我无法修理桌子时，这对我有用
ALTER TABLE Tablename DISCARD TABLESPACE;
ALTER TABLE Tablename IMPORT TABLESPACE;
ALTER TABLE Tablename DISCARD TABLESPACE;
ALTER TABLE Tablename IMPORT TABLESPACE;
回答by qadenza
I got it working with some changes in xampp/phpmyadmin/config.inc.php:
我让它在以下方面进行了一些更改xampp/phpmyadmin/config.inc.php：
Add a $i=1after /* server parameters */
添加$i=1后/* server parameters */
/* Server parameters */
$i = 1
AND fix tablespaces of phpMyAdmin as written in https://stackoverflow.com/a/11506495/2364405
并修复 phpMyAdmin 的表空间，如https://stackoverflow.com/a/11506495/2364405 中所述
