8

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

Improve this question
1
  • the problem is people want a universal recipe while the actual recovery path varies a lot depending on specific scenario. I hope youtu.be/014KbCYayuE helps (yes, it's an hour long video. no I cannot write a guide). Good luck. Commented Jun 6, 2022 at 15:30

5 Answers 5

Reset to default
0

The best solution is to create a new database in the new MySQL installation, export everything you want 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.

Back Story: 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.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

0

following steps I followed. If the scenario matches with you, you can take the same steps as well.

  1. DROP TABLE name_of_your_table
  2. if you ever gave chatGPT your table details for getting some dummy data
    to test API or whatever, take that info again and ask chatGPT to give you create table command accordingly
  3. export SQL file for further backup
Improve this answer

Comments

0

Same happened to me in Windows, lost my old course databases after uninstalling old version and installing new one. When you uninstall the old version of xampp, even though it lets you save the htdocs and mysql/data folder, it will remove the ibdata1 file from there. So after you uninstall, even though you still have all the databases folders in mysql/data now that you lost the corresponding ibdata1 file, they are now useless. Copying a new ibdata1 file from the new installation of xampp will not solve this. Basically there is no way to go back. This could have easily been avoided if the Xampp uninstaller would not have touch the mysql/data folder at all, leaving it to the user to procced, instead of removing few files there and making its content irrelevant after.

But the way how I was able to restore the DB was by using a SQL script file of the entire database with the data inserted on tables (I had one as a backup option to quickly recreate the db from scratch).

Improve this answer

Comments

-2
  1. Run XAMPP as Administrator
  2. Restore Your Database Backup
  3. Change Your MySQL Port 3306 (MariaDB 3307)
Improve this answer

1 Comment

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

Improve this answer

1 Comment

Maybe if you did not uninstall the old xampp version replacing the folder would work like you said. But when you uninstall the old xampp version the mysql/data folder loses the ibdata1 file and its useless.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.