Ingres 11.0 | unloaddb Examples

Was this helpful?

unloaddb Examples

1. The following commands unload and reload the empdata database:

Windows:

cd\mydir\backup
unloaddb empdata
unload
destroydb empdata
createdb empdata
reload
sysmod empdata

UNIX:

cd /mydir/backup
unloaddb empdata
unload.ing
destroydb empdata
createdb empdata
reload.ing
sysmod empdata

VMS:

set default [mydir.backup]
unloaddb empdata
@unload.ing
destroydb empdata
createdb empdata
@reload.ing
sysmod empdata

2. This command unloads the empdata database, specifying separate source and destination directories:

unloaddb empdata -source="misc/loaddir/" -dest="misc/dumpdir"

Copy statements in the reload script would have the form:

copy emps () from 'misc/loaddir/emps.bob'

Copy statements in the unload script would have the form:

copy emps () into 'misc/dumpdir/emps.bob'

3. This command unloads a database to a portable directory:

unloaddb empdata -source="." -dest="."

COPY statements in the reload script would have the form:

copy emps () from './emps.bob'

COPY statements in the unload script would have the form:

copy emps () into './emps.bob'

Last modified date: 01/30/2023