Solved

URGENT! Is it possible to undelete a MySQL database?

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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

789 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