Solved

URGENT! Is it possible to undelete a MySQL database?

Posted on 2003-12-04
5
1,859 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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

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…
I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

920 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

16 Experts available now in Live!

Get 1:1 Help Now