in phpMyAdmin I can see all databases and tables. But when clicking on any table I get the error
Error #1932 – Table ‘mytablename’ doesn’t exist in engine
I tried a lot of solution advises found on Google and Stackoverflow, but nothing helped for me. Is there a way to extract the data as SQL files that I can import them on a clean installation?
I’m working with XAMPP on Windows 11.
I have tried dozens of SO threads and the solution advises there. I was not able to find a solution working for me.
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:autoextendDatabase 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 TABLESmysql 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
3
Answers
I had this problem after reinstalling Xampp to the latest version.
For my case i replaced my xampp/mysql folder with old mysql folder and it works
I had this problem after copying files from an old MySQL install to a different installation of MySQL. I copied a database in
mysql/data/MyDatabaseOldto the new MySQL installation.There is a file called ibdata1 at
mysql/data/ibdata1, which is the system tablespace. This error occurred because, even though I copied the MyDatabaseOld to the new installation, the ibdata1 file in the new installation didn’t have this database. So that is why it says "Doesn’t exist in engine". Basically, the database doesn’t exist in the ibdata1 file. I don’t know if there is a way to edit the ibdata1 file. You can try copy the ibdata1 to the new installation, but I wouldn’t recommend this. The best solution is to create a new database in the new installation, export everything you want copied from the old installation and import into the new installation.If you are using phpMyAdmin, you can follow this link on how to export data https://help.dreamhost.com/hc/en-us/articles/214395738-phpMyAdmin-How-to-backup-or-export-a-database-or-table. And this link for import https://help.dreamhost.com/hc/en-us/articles/214395768-phpMyAdmin-How-to-import-a-database-or-table.