Management Console for Unix database files are located in the following locations:
The data for each database consists of multiple files located in the same directory. All the database files start with the same name as defined by the value in the jdbc.url key. For Management Console for Unix, the database consists of the following files by default:
|console.lck||This file is used to determine if the database is in use. If console.lck exists, the server is currently running. This file is deleted once the database is properly shutdown. DO NOT BACKUP THIS FILE.|
|console||This file contains the extra SQL statements that have modified the console database since the last checkpoint (something like the 'Redo-log' or 'Transaction-log', but just text.) For a normal shutdown this file is deleted once the database has completely shutdown.|
|console.properties||This file contains general settings about the database including the console.properties entry 'modified'. If [modified=yes], the database is either running or was not closed correctly (because the close algorithm sets 'modified' to 'no' at the end).|
|console.script||This file contains the SQL statements that make up the database up to the last checkpoint.|
It is best to perform a backup when the HSQLDB is not running. use normal backup methods, such as archiving the files in a compressed bundle.
To backup a database
Note: If a backup immediately follows a checkpoint, then the console file can also be excluded, reducing the significant files to console.properties and console.script.
You can backup the files while the HSQLDB server is running, but make sure that a shutdown or checkpoint is NOT performed during the backup. If you perform a backup while the server is running, you will need to backup the console file, as well. This file will be deleted once the server is shutdown.
Use the following information to determine if the database was shutdown successfully.
State after shutting down the HSQLDB server:
Aborted database state (may happen by sudden power outage, Ctrl+C in Windows)