mariadb MySQL PHP我的管理员:错误#1932 -表在引擎中不存在

0h4hbjxa  于 2022-11-08  发布在  Mysql
关注(0)|答案(2)|浏览(303)

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

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

我尝试了很多解决方案的建议,发现谷歌和Stackoverflow,但没有帮助我。有没有办法提取数据作为SQL文件,我可以导入他们在一个干净的安装?
我在Windows 11上使用XAMPP。

我已经尝试了几十个SO线程和解决方案建议。我无法找到一个适合我的解决方案。

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

osh3o9ms

osh3o9ms1#

1.以管理员身份运行XAMPP
1.还原数据库备份
1.更改您的MySQL端口3306(MariaDB3307

gkl3eglg

gkl3eglg2#

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

相关问题