Sample Header Ad - 728x90

Table 'any table' doesn't exist in engine without moving anything

0 votes
1 answer
943 views
Today after I guess a month or so I rebooted my server and now I get Table 'ANY TABLE' doesn't exist in engine in every InnoDB table that I want to open in phpMyAdmin. My ISAM tables are fine and working. I saw other people had the same problem after moving files from an old backup to a MySQL directory, but I did not do that. Another odd thing is I have a backup from a machine (it's VMware), but when I recover from those (I tried a backup from 2 days ago and a 1 week old backup) I get the same error, but the database was working fine until today. So I have no SQL backup and just a VMware machine backup, but even a 2 week old full machine backup is not solving my problem. I guess it's because of a change I made a long time ago, but it did not show up until the server reset. Is there is anything I can do to restore my database and get my data back? I'm using XAMPP on Linux. There is no error in running MariaDB. InnoDB force recovery did not help even 6. I moved all data folder + ib_logfiles + ibdata1 on a new XAMPP, but exactly same the error appears.
Asked by user1772630 (1 rep)
Apr 18, 2024, 12:18 AM
Last activity: Apr 21, 2024, 04:32 PM