2. Using Ingres Commands : unloaddb Command—Create Command Files for Unloading and Reloading a Database : unloaddb Example: Unload a Database, Specifying Source and Destination Directories
 
Share this page                  
unloaddb Example: Unload a Database, Specifying Source and Destination Directories
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'