Re: SE tape Backup

I don't feel that backing up .dat and .idx is enough. In addition to that, I run dbschema for all tables, and unload all data. Thus, if an index is corrupted, you can rebuild a table and load the data. Dirk Niemeier wrote: > Hi, > you can use your standard unix backup program. you only have to backup > the .dat and .idx files. > You don't have to use dbexport for backup. > Dirk > > liliano@my-deja.com schrieb: > > > Hi, > > > > Can i use dbexport to backup my database on tape ? > > In "INFORMIX SE 7.2 Administrator guide" (under "Performance Tuning) > > i've read this (!): > > "Do not use the dbexport utility for database backups.Rely on proper > > UNIX backups". > > > > I'm thinking to: > > 1)Use dbexport with -o option to create a backup on hard disk > > 2)Store my backup on tape using Unix (solaris7) tar > > > > Can you help me? > > > > Sent via Deja.com http://www.deja.com/ > > Before you buy. -- Spyros Macris, President Philadelphia Candies, Inc. 1546 East State Street Hermitage, PA 16148 Phone - 724 981 6341 Fax - 724 981 6490 email - spyros@phillyc.com

On Thu, 17 Feb 2000 07:56:32 +0000, Dirk Niemeier <dirk.niemeier@stueken.de> wrote: >Try it. Be sure that all DB-connections are closed and copy all dat/idx files >to an >other maschine with the same directory stucture. >Test it This should work. But if you restore on another machine don't forget the logfile or you can't access the database. When I did this once for a SE 5.0 I ran into trouble when the database logfile did not exist in the expected path. I don't know if this is still true for 7.x. If you can remember only partly it's name you can try "grep" to find the full path in "systables.dat" Axel

Spyros Macris schrieb: > I don't feel that backing up .dat and .idx is enough. > > In addition to that, I run dbschema for all tables, and unload all data. > > Thus, if an index is corrupted, you can rebuild a table and load the data. Try it. Be sure that all DB-connections are closed and copy all dat/idx files to an other maschine with the same directory stucture. Test it, or ask Art if I am right. When you export the data, you can import it on every Informix DB. But for backup it is enough to backup the files (perhaps the transaktion file). Dirk > > > Dirk Niemeier wrote: > > > Hi, > > you can use your standard unix backup program. you only have to backup > > the .dat and .idx files. > > You don't have to use dbexport for backup. > > Dirk > > > > liliano@my-deja.com schrieb: > > > > > Hi, > > > > > > Can i use dbexport to backup my database on tape ? > > > In "INFORMIX SE 7.2 Administrator guide" (under "Performance Tuning) > > > i've read this (!): > > > "Do not use the dbexport utility for database backups.Rely on proper > > > UNIX backups". > > > > > > I'm thinking to: > > > 1)Use dbexport with -o option to create a backup on hard disk > > > 2)Store my backup on tape using Unix (solaris7) tar > > > > > > Can you help me? > > > > > > Sent via Deja.com http://www.deja.com/ > > > Before you buy. > > -- > Spyros Macris, President > Philadelphia Candies, Inc. > 1546 East State Street > Hermitage, PA 16148 > > Phone - 724 981 6341 > > Fax - 724 981 6490 > > email - spyros@phillyc.com

I agree. Also, you can lose referential integrity by using Unix backups, since the backup is not 'instantaneous'. In article <88f7k2$4bv$1@news.xmission.com>, Spyros Macris <spyros@phillyc.com> wrote: > > I don't feel that backing up .dat and .idx is enough. > > In addition to that, I run dbschema for all tables, and unload all data. > > Thus, if an index is corrupted, you can rebuild a table and load the data. > > Dirk Niemeier wrote: > > > Hi, > > you can use your standard unix backup program. you only have to backup > > the .dat and .idx files. > > You don't have to use dbexport for backup. > > Dirk > > > > liliano@my-deja.com schrieb: > > > > > Hi, > > > > > > Can i use dbexport to backup my database on tape ? > > > In "INFORMIX SE 7.2 Administrator guide" (under "Performance Tuning) > > > i've read this (!): > > > "Do not use the dbexport utility for database backups.Rely on proper > > > UNIX backups". > > > > > > I'm thinking to: > > > 1)Use dbexport with -o option to create a backup on hard disk > > > 2)Store my backup on tape using Unix (solaris7) tar > > > > > > Can you help me? > > > > > > Sent via Deja.com http://www.deja.com/ > > > Before you buy. > > -- > Spyros Macris, President > Philadelphia Candies, Inc. > 1546 East State Street > Hermitage, PA 16148 > > Phone - 724 981 6341 > > Fax - 724 981 6490 > > email - spyros@phillyc.com > > -- # unrm / ksh: unrm: not found # man cpio Sent via Deja.com http://www.deja.com/ Before you buy.