For some reason, when I try to open up my tables that are stored in
.ibd files (whether on MySQL or phpmyadmin) it gives me a syntax error, or it says it does not exist.
I've read restore table from .frm and .ibd file? that had similar problem to this, but I don't know how to check if
innodb_file_per_table is enabled, and I'm overall just really confused. I also converted a copy of my
mysql-bin.000002 file to a txt file so I see that the data from my database is not completely lost.
The database was created last year. I have 6 of those
mysql-bin.00000 files, but for some reason the
.000002 is the largest. Right now, I have the
.frm files for all my databases, but I'm at a loss as to how I can restore it back into MySQL, or at least into something I can read.
I'm using WampServer 2.4 and MySQL 5.6.12 on Windows 2003 Server. Also, am I supposed to download a plugin in InnoDB?