background image
<< 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