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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 de Bernardy May 3 '13 at 20:14
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


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

Browse other questions tagged or ask your own question.