createFrom=path attribute

Function

You can specify the createFrom=path attribute in the boot time connection URL to create a database using a full backup at a specified location. If there is a database with the same name in derby.system.home, an error will occur and the existing database will be left intact. If there is not an existing database with the same name in the current derby.system.home location, the whole database is copied from the backup location to the derby.system.home location and started.

The Log files are copied to the default location. The logDevice attribute can be used in conjunction with createFrom=path to store logs in a different location. With createFrom=path you do not need to copy the individual log files to the log directory.

For more information about using this attribute, see "Creating a database from a backup copy" in the Derby Server and Administration Guide.

Combining with other attributes

Do not combine this attribute with rollForwardRecoveryFrom, restoreFrom, or create.

Example

URL: jdbc:derby:wombat;createFrom=d:/backup/wombat