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