2. Using Ingres Commands : movedb Command--Copy Data Locations to Another Machine
 
Share this page                  
movedb Command--Copy Data Locations to Another Machine
Valid on Linux.
The movedb utility copies Vector data locations from one machine to another. Movedb lets you create a backup copy of the database for disaster recovery purposes.
Note:  The locations must be the same on both machines.
This command has the following format:
movedb -source source_name -dest destination name -dbname dbname
        [-key keyfile] [‑nockp] [-trial]
-source source_name
Specifies the name of the source machine.
-dest destination_name
Specifies the name of the destination machine.
-dbname dbname
Specifies the name of the database.
-key keyfile
Specifies the fully-qualified SSH key file. Specifying an authentication key is recommended; otherwise password authentication will be required multiple times instead of once. An authentication key can be generated by using the Linux utility ssh-keygen.
‑nockp
Does not copy ckp, jnl, and dmp directories.
-trial
Performs a trial run copy (no files copied).
movedb Example
Copy the sales database (all database locations) from the host1 machine to the host2 machine. Specify an SSH key file so that password authentication is required only once:
movedb –source host1 –dest host2 –dbname sales -key /home/actian/keyfilename