Tell me more ×
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.
up vote 1 down vote favorite

I accidentally dropped a MySQL database on my server. Are there any ways to recover a dropped database?

share|improve this question
What platform is your MySQL database running on? – Jack Douglas♦ Aug 28 '12 at 14:07
If it was running on a Windows box you might be able to use a simple file undelete utility to recover the deleted file(s). – Max Vernon Aug 28 '12 at 14:10

1 Answer

up vote 2 down vote

There's no easy way to break this to you. It doesn't matter if you dropped a db via phpmyadmin or the commandline. It is gone.

Human error is one reason to have a good backup regimen.

I'm not religious but I'll say a prayer hoping it wasn't anything too important.

share|improve this answer
it was very important, loads of transaction gonna lose – kewl Aug 28 '12 at 7:15
2  
Best I could recommend in that case is unmount the filesystem your datadir was in. Shutdown the server if needed to do that. Call a data recovery service and be prepared to shell out thousands, if not tens of, all while paying for a crap shoot with no garauntees :-\ – atxdba Aug 28 '12 at 7:21

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.