table doesn't exit in engine

andrea_ca_gt's profile image andrea_ca_gt posted 3 years ago in General Permalink

Hi all, I am using HeidySQL with MariaDB on windows. I have several tables in my database and suddenly one table became a view (which I never created) and when I tried to access it, it gives me this error:

  • SQL Error (1932): Table 'db.table' doesn't exist in engine */

Anyone has any tips of how to fix it?

There was a windows update before so I'm not sure if that is related. I checked on the data folder and the files of the table are there

C:\Program Files\MariaDB 10.5\data\db/table.frm and ibd exits

Thanks again

andrea_ca_gt's profile image andrea_ca_gt posted 3 years ago Permalink

Just an update. I managed to fix it by changing the name of the .frm and .ibd files. Open closed the software and then changing them back to the original names. After closing and open HeidiSQL. The table was back. I have no clue why but it worked.

Manfred.P's profile image Manfred.P posted 3 years ago Permalink

@andrea_ca_gt To which names have you changed the tables ?

Manfred.P's profile image Manfred.P posted 3 years ago Permalink

I renamed the files. Unfortunately without success. Then I switched off the server service with "Net Stop Mariadb" and renamed the folder and recreates a new. With "Net Start Mariadb" restarts the service again. Heidisql started and finished again. With "Net Stop Mariadb" the service stopped again. Deleted the empty folder folder and renamed the original folder.

With "Net Start Mariadb" restarted the service again and then HEIDISQL again. The database worked again

Please login to leave a reply, or register at first.