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 create a database each year from the previous year, back up and then clean up the tables. So I have databases for the past 3 years.

This year I did not do a backup and accidentally dropped the database of 2011. The schema is always the same for all the databases, but of course the entries are different for each year.

After dropping the database of 2011, the folder no longer exists in C:\Program Files\MySQL\MySQL Server 5.0\data, but I see ib_logfile0 and ibdata1 files under the above path. Is there any way I can restore the dropped database?

There was no backup done for 2011 and I do not know what is binary logging.

share|improve this question
2  
when was your last full backup of the 2011 database and do you have binary logging enabled? –  Derek Downey Sep 28 '11 at 16:58
    
Why you had not maintain the backup for database 2011? as we all know that backup helps us to restore database if any disaster, accidental drop or delete situations happen on the database. You can try Stellar Phoenix window data recovery software to restore your dropped database. It is a award winning software and recover dropped or deleted data. From the next time maintain a proper backup of your data. For binary logging visit here: dev.mysql.com/doc/refman/5.1/en/stored-programs-logging.html –  user3646 Sep 29 '11 at 7:32

1 Answer 1

You can try and use data recovery software to recover the blocks as odds are the blocks haven't been overwritten yet. If they have been overwritten, then the data is gone.

I'm sorry to say, but you've just learned why backups are important.

share|improve this answer
2  
why they call it "learning the hard way" –  randy melder Sep 28 '11 at 19:37

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.