Solved

URGENT! Is it possible to undelete a MySQL database?

Posted on 2003-12-04
5
1,858 Views
Last Modified: 2008-02-26
The subject says it all. A database was deleted by mistake and a lot of work was put into it since the last backup. Is it possible to retreive the lost data (please?)

MySQL is running on Linux
0
Comment
Question by:jmfreema
5 Comments
 
LVL 7

Expert Comment

by:mquiroz
ID: 9878007
maybe you can try a hard disk data recovery  software or company but there's not an easy task...
0
 
LVL 17

Expert Comment

by:BudDurland
ID: 9879038
Running under NetWare, this would be trivial.  With *nix (or windoze, for that matter),  it's quite a bit more difficult.  Sorry I can't be on specific help...
0
 
LVL 17

Expert Comment

by:Squeebee
ID: 9879451
Do you have log files?
0
 
LVL 7

Accepted Solution

by:
jconde earned 500 total points
ID: 9894929
MySQL doesn't have any features to "undelete" a deleted database.  I have seen several utilities for both Windows and Linux which can accomplish this;  Some of them are free, some others aren't.  In the mean-time, while you attempt to recover your database back, try not to use your server too much.

Maybe the following links will help you out:
For Linux: http://recover.sourceforge.net/linux/
For Win32: http://www.quetek.com/prod02.htm


0
 

Author Comment

by:jmfreema
ID: 9897462
Thanks for those links. I only wish I could have gotten ahold of them three days ago. I'm still going to download it and try, but the files are surely gone by now (I cant stop usage of the server and new files were being created daily, plus the attempts to reconstruct the deleted database).

This would be good to have in the future anyway...
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Loading csv or delimited data files to MySQL database is a very common task frequently questioned about and almost every time LOAD DATA INFILE comes to the rescue. Here we will try to understand some of the very common scenarios for loading data …
More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now