Java DB

Apache Derby

Derby Server and Administration Guide

Derby Getting Started
Derby Reference Manual
Derby Developer's Guide
Derby Performance Tuning
Derby Server and Admin Guide
Derby Tools and Utilities
Derby Server and Admin Guide
-Part one: Derby Server Guide
-Derby in a multi-user environment
-Using the Network Server with preexisting Derby applications
-The Network Server and JVMs
-Installing required jar files and adding them to the classpath
-Starting the Network Server
-Shutting down the Network Server
-Obtaining system information
-Accessing the Network Server by using the network client driver
-Accessing the Network Server by using a DataSource object
-XA and the Network Server
-Using the Derby tools with the Network Server
-Differences between running Derby in embedded mode and using the Network Server
-Setting port numbers
-Managing the Derby Network Server
-Managing the Derby Network Server remotely by using the servlet interface
-Derby Network Server advanced topics
-Derby Network Server sample programs
-Part two: Derby Administration Guide
-Checking database consistency
-Backing up and restoring databases
-Replicating databases
-Logging on a separate device
-Obtaining locking information
-Reclaiming unused space

 

Creating a database from a backup copy

To create a database from a full backup copy at a specified location, specify the createFrom=Path attribute in the boot time connection URL.

If there is already 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 system will copy the whole database from the backup location to derby.system.home and start it.

The log files are also copied to the default location. You can use the logDevice attribute in conjunction with the createFrom=Path attribute to store logs in a different location. With the createFrom=Path attribute, you do not need to copy the individual log files to the log directory.

For example, to create the sample database from a backup copy in c:\mybackups\sample, the connection URL should be:
jdbc:derby:sample;createFrom=c:\mybackups\sample

For more information, see "createFrom=path attribute" in the Derby Reference Manual.

 

javadb@jdbcurl.com