Backing up INFORMIX-online databases (fwd)
Ralph Gyoery writes: > > Informix : 4.00.UH1 Online > Platform : SUN 4/490 > SunOS 4.1.1 > > I would like to take a checkpoint / snapshot of individual databases > residing on a common raw partition. The reading I have done so far > let's me take an archive of the whole partition onto tape or to unload > a database (using tbunload) to tape. The second option seems the closest > thing to a checkpoint however it has a few shortcomings: > -> has to go to tape > -> doesn't save privileges or synonyms > > This is unacceptable, what I would like is to be able to do is: > -> take a complete image of a database that can be used to replace > the database, without having to rebuild it (indexing, privileges) > -> the image / checkpoint can be saved to a file on disk > -> the image dump can be done in batch mode (a command that can be run > via a shellscript) > -> is anyone is familiar with INGRES, my request is for a 'ckpdb' > command. > > Could you please mail me your responses. > Thankyou > Ralph. > > Ralph Gyoery. > SBC Dominguez Barry > > MHSnet : ralph@dbsm.oz.au > INTERNET GATEWAY : ralph%dbsm.oz.au@munnari.oz.au > -- > > > Ralph Gyoery. > Midland Montagu Australia Limited. > Ralph - TBUNLOAD works fine for the purpose described, it does *not* require use of tape. The following is a csh script I use regularly for exactly the same purpose as you suggest. ------SNIP-------SNIP-------SNIP-------SNIP-------SNIP-------SNIP-------SNIP # # Single database backup to file using tbunload # # greg bryan 19 Jan 91 # # switch ($#argv) case 1: set DBNAME = $1 set BUFILE = TU.$DBNAME.$$ breaksw case 2: set DBNAME = $1 set BUFILE = $2 breaksw default: echo "Usage: dbu <database name> [<file name>]" exit 1 breaksw endsw echo "ready to tbunload database: $DBNAME into file: $BUFILE" echo touch $BUFILE tbunload -t $BUFILE $DBNAME ------SNIP-------SNIP-------SNIP-------SNIP-------SNIP-------SNIP-------SNIP I hope this helps. ------------ DHL WORLDWIDE EXPRESS ------------------------------------------- Greg Bryan gbryan@ssf-sys.dhl.com DHL Systems Data Administrator uunet!ssf-sys.dhl.com!gbryan San Francisco -------------------------------------------------------------------------------