|
|
1.1 ! root 1: .th COPYDB UNIX 3/14/79 ! 2: .sh NAME ! 3: copydb \- create batch files to copy out a data base and restore it. ! 4: .sh SYNOPSIS ! 5: .bd copydb ! 6: [ ! 7: .bd \-u\c ! 8: .it name ! 9: ] database full-path-name-of-directory ! 10: [ relation ... ] ! 11: .sh DESCRIPTION ! 12: .it Copydb ! 13: creates two ! 14: \*(II command files in the directory: ! 15: .bd Copy.out, ! 16: which contains Quel instuctions which will copy all relations owned by the user ! 17: into files in the named directory, ! 18: and ! 19: .bd copy.in, ! 20: which contains instructions to copy the files into relations, ! 21: create indexes and do modifies. ! 22: The files will have the same names as the relations with ! 23: the users \*(II id tacked on the end. ! 24: (The directory MUST NOT be the same as the data base directory ! 25: as the files have the same names as the relation files.) ! 26: The ! 27: .bd \-u ! 28: flag may be used to run ! 29: .it copydb ! 30: with a different user id. ! 31: (The fact that ! 32: .it copydb ! 33: creates the copy files does not imply that the user ! 34: can necessarily access the specified relation). ! 35: If relation names are specified only those relations will be ! 36: included in the ! 37: copy files. ! 38: .s3 ! 39: .it Copydb ! 40: is written in Equel and will access the database in the usual manner. ! 41: It does not have to run as ! 42: the \*(II user. ! 43: .sh EXAMPLE ! 44: .nf ! 45: chdir /mnt/mydir ! 46: copydb db /mnt/mydir/backup ! 47: ingres db <backup/copy.out ! 48: tp r1 backup ! 49: rm \-r backup ! 50: ! 51: tp x1 ! 52: ingres db <backup/copy.in ! 53: .fi ! 54: .sh DIAGNOSTICS ! 55: .it Copydb ! 56: will give self-explanatory diagnostics. ! 57: If ``too many indexes'' is reported it means that more than ten indexes have ! 58: been specified on one relation. ! 59: The constant can be increased and the program recompiled. ! 60: Other limits are set to the system limits. ! 61: .sh BUGS ! 62: .it Copydb ! 63: assumes that indexes which are ISAM do not need to be remodified. ! 64: .it Copydb ! 65: cannot tell if the relation was modified with a fillfactor or ! 66: minpages specification. ! 67: The ! 68: .bd copy.in ! 69: file may be edited to reflect this.
This archive runs on limited infrastructure. Preserving old code on modern bandwidth. Automated agents are requested to crawl responsibly.