Kbase 12564: How to dump & load data of a large database with no diskspac
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
How to dump & load data of a large database with no diskspac
This has been a common question on UNIX platforms. When using this
routine replace the occurances of REWIND on the command line with the
name of a rewind devices on your system.
DUMP ROUTINE:
/* Ensure tape is at the start */
unix dd if=/dev/REWIND of =/dev
ull bs=5k
/* dump each file in turn to the REWIND tape device.
Individual dumps have to be separated by a period. */
output through dd of=/dev/REWIND bs=5k.
for each file_1:
export file_1.
end.
put "." skip.
for each file_2:
export file_2.
end.
put "." skip.
/* continue to do this for all your files, substitute your unique file
names for file_1, file_2,... file_n. */
for each file_n:
export file_n..
end.
put "." skip.
output close.
LOAD ROUTINE:
/* Reposition tape to the beginning. */
unix dd if=/dev/REWIND of=/dev
ull bs=5k
/* read tape via dd using REWIND tape device */
input through dd if=/dev/REWIND bs=5k
repeat:
create file_1.
import file_1.
end
repeat:
create file_2.
import file_2.
end.
/* do this for all your files */
Please note: On some systems dd errors may occur in the initial
output. This program is meant as a guideline. The user is encouraged
to verify tapes after dumping.
Progress Software Technical Support Note # 12564