首页
学习
活动
专区
工具
TVP
发布
社区首页 >问答首页 >MySQL phpMyAdmin:错误#1932 -在引擎中不存在表格

MySQL phpMyAdmin:错误#1932 -在引擎中不存在表格
EN

Stack Overflow用户
提问于 2022-04-08 23:08:14
回答 2查看 6.8K关注 0票数 3

在phpMyAdmin中,我可以看到所有的数据库和表。但是,当单击任何表时,我会得到错误。

错误#1932 -引擎中不存在表“mytablename”

我尝试了很多解决方案的建议,发现谷歌和斯塔克溢出,但对我没有任何帮助。是否有一种方法可以将数据提取为SQL文件,以便在干净的安装中导入它们?

我正在Windows 11上使用XAMPP。

,我已经尝试了几十个这样的线程,解决方案建议在那里。我无法找到适合我的解决方案。

Xampp-mysql - "Table doesn't exist in engine" #1932

- I tried it with new and old files of ib_logfile0, ib_logfile1 and ibdata1

- I checked the my.ini for innodb_data_file_path = ibdata1:10M:autoextend

Database corruption with MariaDB : Table doesn't exist in engine

- Tried to backup with mysqldump -u root --all-databases > sql_file.sql

Result: mysqldump: Got error: 1932: "Table 'mytablename' doesn't exist in engine" when using LOCK TABLES

mysql 1932 table doesn't exist in engine

- The old pcs xampp version was 8.1.2, my new one 8.1.4 but i also tried to install the old 8.1.2 version resulting in the same Error.

Mysql Table 'db.table' doesn't exist in engine

- I'm on Windows, not Ubuntu (Linux)

how to fix #1932 - Table does not exist in engine

- I already copied the old files which are mentioned, without success.

phpMyAdmin error 1932 - table doesn't exist in engine

- Running the ALTER command in phpmyadmin also results in Error "#1932 - Table XYZ doesn't exist in engine"

- Changing the $i = 0 to $ = 1 in xampp/phpmyadmin/config.inc.php just brought me php errors.

#1932 table 'tablename' doesn't exist in engine

- I have no SQL-Backup to feed, otherwise I would have taken this from the beginning.

MySql - Error Code: 1932. Table doesn't exist in engine

- I did not add enum field

#1932 -Table doesn't exist in engine

- No solution advises here

EN

回答 2

Stack Overflow用户

发布于 2022-04-08 23:36:41

Administrator

  • Restore运行XAMPP作为3307)

数据库备份

  • 更改MySQL端口3306 (MariaDB 3307)

)

票数 -1
EN

Stack Overflow用户

发布于 2022-08-24 12:40:04

在将Xampp重新安装到最新版本后,我遇到了这个问题。对于我的情况,我用旧的mysql文件夹替换了xampp/mysql文件夹,它可以工作。

票数 -1
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/71803954

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档