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.

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
2  
Yes, from backup. One reason those exist (or: should exist) is user error ;) –  TomTom Jul 1 '13 at 13:14
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.