<< Content 1
|
About this guide >>
Content 2
<< Content 1
|
About this guide >>
Version 10.8 Derby Server and Administration Guide
ii
Backing up and restoring databases
.....................................................................
60
Backing up a database.......................................................................................
60
Restoring a database from a backup copy.........................................................
63
Creating a database from a backup copy...........................................................
64
Roll-forward recovery..........................................................................................
64
Importing and exporting data
.................................................................................
66
Methods for running the import and export procedures......................................
66
Bulk import and export requirements and considerations...................................
67
Bulk import and export of large objects..............................................................
68
File format for input and output...........................................................................
69
Importing data using the built-in procedures.......................................................
70
Exporting data using the built-in procedures.......................................................
74
Examples of bulk import and export...................................................................
76
Running import and export procedures from JDBC............................................
77
How the import and export procedures process NULL values............................
77
CODESET values for import and export procedures..........................................
78
Replicating databases
.............................................................................................
78
Starting and running replication..........................................................................
79
Stopping replication.............................................................................................
80
Forcing a failover.................................................................................................
80
Replication and security......................................................................................
81
Replication failure handling.................................................................................
81
Logging on a separate device
................................................................................
82
Using the logDevice=logDirectoryPath attribute..................................................
83
Example of creating a log in a non-default location............................................
83
Example of moving a log manually.....................................................................
83
Issues for logging in a non-default location........................................................
83
Obtaining locking information
................................................................................
84
Monitoring deadlocks...........................................................................................
84
Reclaiming unused space
.......................................................................................
85
Trademarks
..........................................................................................................................
86