Re: Restoring ONE table from a backup?
Howdy 2!
Please include me in any direct responses to Bill.
Thanks,
----------------------------------------------------------------------
-- --
-- Dick Augustus Embry-Riddle Aeronautical University --
-- augustur@db.erau.edu (904)226-7609, voice --
-- (904)226-6220, fax --
-- --
-- "For most people, the sky is the limit; for those who love --
-- aviation, the sky is home." - Jack R. Hunt, past President --
----------------------------------------------------------------------
______________________________ Reply Separator _________________________________
Subject: Restoring ONE table from a backup?
Author: jaegerwl@wckn.dorm.clarkson.edu (Bill Jaeger) at Internet-mail
Date: 7/7/95 12:39 AM
Howdy!
I've got an Informix v5.0x database up and running with about 15 gigs of data.
Of that 15 gigs of data, one table (perhaps 50K in size!) has become corrupt.
I have complete, current level 0 backups that were done with tbtape.
My problem is that I need to find a way to extract ONLY this one table from
the level 0 backup set, and then insert that table into the database in lieu
of the corrupt version.
Since the Informix manuals are really lacking in this area I called Informix
for guidance. The only thing tech support could suggest, other than upgrading
to version 7 (great, thanks...) was to do a level 0 dump of the current
database, restore the level 0 with the table I need, dbunload the needed table,
nuke the database again, re-restore the current version, and then dbload the
table.
Is it just me, or does this seem ludicrous? Backups are great, but I'm not
confident enough to trust the backups unnecessarily - moving 15 gigs of data
back and forth to retrieve a 50K table just doesn't seem to make sense.
Since I don't agree with Informix's advice, I went digging through the
tapes with dd and found the data/table that I need to restore. Unfortunately
this data is not in a directly restoreable format.
So, what I'm asking is:
- is it possible to somehow restore a single table from a tbtape dump?
Using a shareware/PD/homegrown utility would be fine...
- does anyone know the format of the data on the tape so that I could
somehow piece it together?
If anyone has any suggestions, please let me know!
Thanks a bunch,
-Bill :)
bill@wckn.dorm.clarkson.edu