5

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: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

Tactic
  • 83
  • 1
  • 1
  • 5
  • the problem is people want a universal recipe while the actual recovery path varies a lot depending on specific scenario. I hope https://youtu.be/014KbCYayuE helps (yes, it's an hour long video. no I cannot write a guide). Good luck. – akuzminsky Jun 06 '22 at 15:30

3 Answers3

0

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/MyDatabaseOld to 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.

r3n4y
  • 77
  • 3
-1
  1. Run XAMPP as Administrator
  2. Restore Your Database Backup
  3. Change Your MySQL Port 3306 (MariaDB 3307)
Gev99
  • 173
  • 5
  • Running as administrator didn't changed anything. Which Backup you mean? Unfortunatelly i don't have SQL-Backups, just the old mysql/data folder. Changing the Port also didn't change anything. Same error. – Tactic Apr 09 '22 at 11:42
-2

1

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

vimuth
  • 5,064
  • 33
  • 79
  • 116
user15505863
  • 1
  • 1