I reformatted my C drive, reinstall mysql for windows then deleted my 2 log files + ibdata1. I set the data path in my config file and was able to connect to my database. I see all my databases however if i try to select any data i get an error
I remembered I needed to set files per table so i wrote
I restarted mysqld and I still get an error. This is what i get specifically. t is the name of my database (its a test database). I see all the databases i have with
show tables; works as well. But I can't select anything or
desc TABLE. My database are 60gb in total so i'm worried i broke it all.
mysql> select * from inc; ERROR 1146 (42S02): Table 't.inc' doesn't exist