12.3.2 dbrestore.bat (restoring the database)
- Organization of this subsection
(1) Function
Restores the database used by JP1/DH - Server from the backup file. Before executing this command, shut down the JP1/DH Web application server (Cosminexus J2EE server).
(2) Executor
A user with a built-in Administrator account or with Administrator permissions executes the command from the command prompt.#
- #
-
Do not execute a command directly. Use the command prompt to execute a command.
(3) Format
dbrestore.bat DB-password restore-source-folder [restore-file-name]
(4) Arguments
- DB-password
-
Specify the database password.
- restore-source-folder
-
Specify the destination folder where the database backup file is stored with an absolute path.
Specify the absolute path length no more than 200 bytes.
- restore-file-name (optional)
-
Specify the name of the backup file to be used for restoring the database.
If you omit this argument, dbbackup.dump is used for restoration.
(5) Execution results
The data in the specified backup file is restored to the database.
(6) Return codes
|
Return code |
Description |
Operation after an event occurrence |
Occurrence condition |
|---|---|---|---|
|
0 |
Normal |
-- |
Restoration succeeded. |
|
4 |
Warning |
Interrupts command processing. |
|
|
8 |
Error |
Interrupts command processing. |
Restoration failed. |
|
16 |
Warning |
Interrupts command processing. |
Execution of the command is canceled during confirmation response for shutting down the JP1/DH Web application server (Cosminexus J2EE server). |
(7) Output message (Output destination: stdout)
|
No. |
Message |
Return code |
Operation after an event occurrence |
Action to be taken by the operator |
Occurrence condition |
|---|---|---|---|---|---|
|
1 |
The restoration will start. |
-- |
Starts command execution. |
None |
When a command is executed |
|
2 |
Successfully finished the restoration. Press any key. |
0 |
Terminates command execution. |
None |
When restoration succeeded |
|
3 |
Specify the DB password in the argument. Press any key and try again. |
4 |
Terminates command execution. |
Specify the database password as the argument, and then re-execute the command. |
When a command is executed without the database password specified as the argument |
|
4 |
Specify the restore source folder in the argument. |
4 |
Terminates command execution. |
Specify the restore source folder as the argument, and then re-execute the command. |
When a command is executed without the argument specified |
|
5 |
The specified folder does not exist. Press any key and try again. |
8 |
Terminates command execution. |
Make sure that the specified restore source folder is correct. |
When an incorrect folder is specified as the argument |
|
6 |
******* does not exist in the specified folder. |
8 |
Terminates command execution. |
Make sure that the specified restore source folder and restore file name are correct. |
When an incorrect folder or restore file name is specified as the argument |
|
7 |
Did not successfully finish the restoration. Press any key and try again.# |
8 |
Terminates command execution. |
Check the content of the output error message, remove the cause of the error, and then re-execute the command. |
When restoration failed |
|
8 |
Confirm that the DH Web application server is suspended before continuing. Continue? (y/n) |
-- |
Waits for user response. |
Select y to continue execution, or n to cancel execution. |
When a command is executed |
|
9 |
Canceled command execution. Press any key. |
16 |
Terminates command execution. |
If you selected n in No. 8, agree to the confirmation item and then press any key. |
When n is selected in No. 8 |
#: If an error occurs within the database, this error message is output after an error message is output by the database.
(8) Notes on using the command
Do not execute a command directly. Use the command prompt to execute a command.
If you have enabled UAC (User Account Control) in the operating system, use one of the following ways to execute a command:
-
Log in as a built-in Administrator user, start the command prompt, and then execute a command.
-
Log in as a user with Administrator permissions, start the command prompt by clicking Run as Administrator, and then execute a command.
-
Execute a command from a shortcut for the command prompt with the elevated privileges created at the time of JP1/DH - Server installation.#
- #
-
If you use a command prompt in this way in Windows Server 2012, Windows Server 2012 R2 or Windows Server 2016, you need to install Microsoft .NET Framework 3.5. For details about how to install Microsoft .NET Framework 3.5, see D. Installing .NET Framework 3.5.
Simultaneous executions of commands on the same machine are not supported.