Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

table doesn't exit in engine

andrea_ca_gt's profile image andrea_ca_gt posted 2 months 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 2 months 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.

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




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.