|
|
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.