I have to set up a database copy on my local computer. The problem is that that I have given just the raw database table files (.frm, .ibd, .MYD, .MYI).
I created the database by creating a folder in MySQL's data folder and moved all database files there.
The problem is that some tables seem to work correctly the ones with MyISAM storage engine (.frm, .MYD, .MYI), I can access information in them, see their structure.
My problem is with the tables with InnoDB storage. I cant see their structure in MySQL workbench and when I try to select data from them MySQL spits out an error "Table 'table_name' doesn't exist".
There are two files per one InnoDB table (.frm and .ibd).
To fix this problem I tried to enable innodb_file_per_table, I added to my.ini file in MySQL root folder line
innodb_file_per_table = TRUE but this does not solve anything.
I checked working InnoDB tables in my other MySQL databases and there are the same two files per table (.frm and .ibd).
I will include bellow screenshots of what I described for more clarity
The problematic table example:
Ok table example:
Could someone help me out please, Im hoping I was descriptive enough.