2. Using Ingres Commands : relocatedb Command—Move a Location to a New Location : relocatedb Example: Relocate Dump Files
 
Share this page                  
relocatedb Example: Relocate Dump Files
The following command relocates the dump location for the empdata database to newdump:
relocatedb empdata -new_dump_location=newdump
This command example does the following:
Performs an update to the iidbdb: update iidatabase.dmpdev=’newdump’ where name=’empdata’. (This can be verified by connecting to the iidbdb database and doing a select from iidatabase where name=’empdata’.)
Updates the dump location in the configuration file. (This can be verified by examining the output of the infodb empdata command.)
Copies dump files from the old dump location to the new dump location.
Deletes dump files from the old dump location.