Recover dropped database Post: 302311869

Sponsored Content

Operating Systems Linux SuSE Recover dropped database Post 302311869 by choogendyk on Wednesday 29th of April 2009 10:01:25 PM

04-29-2009

Registered User

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.

choogendyk

View Public Profile for choogendyk

Find all posts by choogendyk

8 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

are dropped packets a sign of network problem?

in a xen environment , i see a lot op dropped packets via netstat -i Is this a sign of network problems, or is it normal to see this kind of numbers? i'm not sure how to interprete the data. is this normal, bad, critical. What are your stats on this? I guess i have a xen issue of some sort,...

2. Ubuntu

System chrashe , dropped into Busybox

This is the mistake that i've done : First of all go to /etc/apt/sources.list folder from terminal or using file manager ... than copy the content of sources.list in to your adequate source.list. Create a file named sources.list.bt and paste the same content In the end open the...

3. Shell Programming and Scripting

CRON Job to copy database and replace existing database

I have a reseller account with hostgator, which means i have WHM and Cpanel. I have set up a staging environment for one of my wordpress installations (client website), which is essentially sitting at staging.domain.com (live site is at domain.com). The staging website is a complete copy of the...

4. News, Links, Events and Announcements

MySQL dropped in favor of MariaDB

Fedora and openSUSE will replace MySQL with MariaDB: Oracle who? Fedora & openSUSE will replace MySQL with MariaDB | ZDNet The article also has a comment that Chakra is planning on doing the same. No doubt the Fedora based distributions are planning to do the same.

5. UNIX for Dummies Questions & Answers

MySQL Database Missing on UNIX server. Possible to recover?

My dedicated server is VERY old (running Apache/1.3.37 (Unix) PHP/4.4.4 FrontPage/5.0.2.2510). We have a script that runs and manages our customer database. Early in the morning last Friday, it was working fine and processed data as usual. Later in the day, we got this error: Cannot...

6. Solaris

Recover Solaris 11 pkg database

Hi, I was messing with pkgsrc and wanted to start fresh so I manually deleted the /var/pkg directory on Solaris 11 :eek: (of course I was supposed to delete the /var/db folder instead)... Anyways... I've basically bricked the Solaris11 Package Manager. Do you know if there is any way to...

7. UNIX for Advanced & Expert Users

Find User who dropped table in teradata DB

HI Team Is there a way to track which user dropped the table in Teradata ? Please share the query or approach . Thanks

8. Shell Programming and Scripting

Records not dropped from UNIX Script

Hi All, As per my biz requirement, I need to drop the partition from our PROD table based on the retention period. Hence I have written the script and called the drop partition procedure within the script. The procedure is working fine and droped the partition from the table when I execute...

LEARN ABOUT DEBIAN

git-lost-found

GIT-LOST-FOUND(1)						    Git Manual							 GIT-LOST-FOUND(1)

NAME

       git-lost-found - Recover lost refs that luckily have not yet been pruned

SYNOPSIS

       git lost-found

DESCRIPTION

       NOTE: this command is deprecated. Use git-fsck(1) with the option --lost-found instead.

       Finds dangling commits and tags from the object database, and creates refs to them in the .git/lost-found/ directory. Commits and tags that
       dereference to commits are stored in .git/lost-found/commit, and other objects are stored in .git/lost-found/other.

OUTPUT

       Prints to standard output the object names and one-line descriptions of any commits or tags found.

EXAMPLE

       Suppose you run git tag -f and mistype the tag to overwrite. The ref to your tag is overwritten, but until you run git prune, the tag
       itself is still there.

	   $ git lost-found
	   [1ef2b196d909eed523d4f3c9bf54b78cdd6843c6] GIT 0.99.9c
	   ...

       Also you can use gitk to browse how any tags found relate to each other.

	   $ gitk $(cd .git/lost-found/commit && echo ??*)

       After making sure you know which the object is the tag you are looking for, you can reconnect it to your regular .git/refs hierarchy.

	   $ git cat-file -t 1ef2b196
	   tag
	   $ git cat-file tag 1ef2b196
	   object fa41bbce8e38c67a218415de6cfa510c7e50032a
	   type commit
	   tag v0.99.9c
	   tagger Junio C Hamano <junkio@cox.net> 1131059594 -0800

	   GIT 0.99.9c

	   This contains the following changes from the "master" branch, since
	   ...
	   $ git update-ref refs/tags/not-lost-anymore 1ef2b196
	   $ git rev-parse not-lost-anymore
	   1ef2b196d909eed523d4f3c9bf54b78cdd6843c6

GIT

       Part of the git(1) suite

Git 1.7.10.4							    11/24/2012							 GIT-LOST-FOUND(1)