The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Operating Systems > Linux > SuSE
.
google unix.com



SuSE SUSE Linux is a major operating system. The developer rights are owned by Novell, Inc.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
are dropped packets a sign of network problem? progressdll UNIX for Dummies Questions & Answers 1 10-10-2007 03:51 PM
HDD damaged, help me to recover data littleghost UNIX for Dummies Questions & Answers 1 06-01-2004 08:51 PM
how to recover with awk mips Shell Programming and Scripting 1 04-08-2004 11:18 AM
Recover mount point here2learn UNIX for Dummies Questions & Answers 1 11-11-2003 02:33 PM
Recover A password SmartJuniorUnix Security 3 05-27-2001 01:25 PM

Closed Thread
English Japanese Spanish French German Portuguese Italian Dutch Swedish Russian Norwegian Hungarian Hebrew Danish Bulgarian Greek Powered by Powered by Google
 
LinkBack Thread Tools Search this Thread Rate Thread Display Modes
  #1 (permalink)  
Old 04-29-2009
Eastme Eastme is offline
Registered User
  
 

Join Date: Apr 2009
Posts: 3
Recover dropped database

I have deleted a database. I restored it again with a backup.
Now we lost some data of two days.
Is it possible to restore this lost data?
  #2 (permalink)  
Old 04-29-2009
pludi's Avatar
pludi pludi is offline Forum Staff  
Moderator
  
 

Join Date: Dec 2008
Location: .at
Posts: 1,884
What database? What version? How much do you know about the database? How long until someone notices and finds out it was you?
  #3 (permalink)  
Old 04-29-2009
Eastme Eastme is offline
Registered User
  
 

Join Date: Apr 2009
Posts: 3
Quote:
Originally Posted by pludi View Post
What database? What version? How much do you know about the database? How long until someone notices and finds out it was you?
MySQL database
I already reported it so everyone is informed.
  #4 (permalink)  
Old 04-29-2009
choogendyk choogendyk is offline
Registered User
  
 

Join Date: Jan 2009
Location: Massachusetts
Posts: 41
Since you restored from a backup, I presume that was the last full backup? In other words, if you had a full backup from last night, it seems you would have chosen that. Then you would have only lost today's work.

So, do you have a database transaction log file? Or an incremental backup from last night?

If you provide more information, someone might be able to help. Or you might answer your own question. However, if you don't have the answers, and don't have a transaction log, then it's likely that you've simply lost the data (you're not running zfs snapshots or a NetApp with snapshots are you?).
  #5 (permalink)  
Old 04-29-2009
Eastme Eastme is offline
Registered User
  
 

Join Date: Apr 2009
Posts: 3
The transactionlog option was not enabled. There also wasn't a backup from last night. The only thing I had was the backup from two days ago. So I was lucky with that. But isn't there a way to recover the data? It is still on the disk isn't it?

Last edited by Eastme; 04-29-2009 at 09:34 PM..
  #6 (permalink)  
Old 04-29-2009
choogendyk choogendyk is offline
Registered User
  
 

Join Date: Jan 2009
Location: Massachusetts
Posts: 41
OK. So we know (and you know) what you are up against. It may or may not still be on disk. The system is live. The more it is used, and the less free space there is on the system, the more likely that the blocks will get re-used and the data over-written. Time is of the essence, and you have already lost too much time.

I haven't had to do the kind of recovery you are talking about. So someone else will have to give you some direction on this. The advice I know is that faced with such a situation, you should immediately stop using the system. Don't do anything until you have booted it off a CD with the recovery software or put the drive in another system where you have the recovery software. It seems you are unable to do that. Perhaps you can do something like dd the whole drive to another drive. Maybe an external mounted drive by firewire or usb? Then you may have a chance of recovering from that drive.
Closed Thread

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On




All times are GMT -4. The time now is 05:35 PM.


Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited. Language Translations Powered by .
vBCredits v1.4 Copyright ©2007 - 2008, PixelFX Studios
The UNIX and Linux Forums Content Copyright ©1993-2009. All Rights Reserved.Ad Management by RedTyger

Content Relevant URLs by vBSEO 3.2.0