Creating a Database From a Backup Copy

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 example, to create the toursDB database using a backup copy in c:\mybackups\sample, the connection URL should be:

jdbc:derby.sample;createFrom=c:\mybackups\sample