Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

By accident, I have deleted the ibdata1 file in the MySQL directory because MySQL wasn't functioning correctly.

After reading so many forums, I found a post that recommended deleting the 3 files ib_logfile0, ib_logfile1 and ibdata1 from the MySQL directory to let InnoDB load again and MySQL come up. And this what I have did.

But now when InnoDB loads as engine the tables disappear.

After I do a graceful restart, InnoDB disappears totally from the server ("have_innodb | No"). But I can see all tables again for databases using InnoDB.

What I'm looking for is a way to load all the tables correctly than ask ibdata to state them as InnoDB then let the InnoDB engine function correctly.

share|improve this question
    
Should go to DBA... –  Denis May 3 '13 at 20:14
1  
Is there anything relevant in /var/lib/mysql/host_name.err that you could paste into your question? Also, I don't quite follow your last sentence - are you hoping to get your data back, or do you have an export? –  Nathan Jolly May 5 '13 at 4:04

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.