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

I have accidently deleted the 'ibdata1' file on the server having innodb, Is there any way I can recover it?

the mysql service has restarted since the deletion.

share|improve this question
Yes, from backup. One reason those exist (or: should exist) is user error ;) – TomTom Jul 1 '13 at 13:14

As you probably know, you've deleted your InnoDB data file. Your options are basically to restore from backup if you have one, or hire a data recovery company with MySQL knowledge to see what they can salvage off the disks. Some of the MySQL consulting firms like Percona and Pythian might be able to help you there, but it won't be cheap, and they might not be able to recover much. If you want to try recovering the deleted file, stopping all write activity on the filesystem that held ibdata1 or remounting it read-only as soon as possible will increase the likelihood that someone will be able to retrieve anything.

share|improve this answer

Your Answer


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

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