Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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

innodb_file_per_table

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 databases. 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
share|improve this question

closed as off topic by mdpc, Ward, Scott Pack, TheCleaner, Tom O'Connor Dec 26 '12 at 12:28

Questions on Server Fault are expected to relate to server, networking, or related infrastructure administration within the scope defined by the community. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about reopening questions here.If this question can be reworded to fit the rules in the help center, please edit the question.

1  
You should have made a backup. –  Michael Hampton Dec 24 '12 at 6:16

2 Answers 2

You deleted the data when you deleted ibdata1 file.

share|improve this answer
    
I guess but thats what the documentation told me to do. I did have a backup. I figured it out and posted my answer –  acidzombie24 Dec 24 '12 at 3:26

The problem was the fresh my.ini file no longer had the innodb_data_home_dir="c:/path/to". I looked at my ini file from a external HD for a different database. I must have a different version of the installer/mysql (even though its still 5.5)

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.