Databases

Borg will create an HSQLDB database in a default location when started after the first install. Most users should never alter the database settings. Some users may want to alter the location of the database, for example to be on a removable drive.

For those users that want to change the default settings, the available choices are:

· HSQLDB

· MySQL

There is also a Generic JDBC option, which takes a jdbc url. This can be used by more advanced users if non-standard HSQLDB or MySQL URL options are needed. It is not guaranteed to work in all cases.

HSQLDB

BORG supports the storage of data in an embedded HSQLDB database. BORG will manage the HSQLDB files without any actions from the user. No pre-requisite software is needed. Just select the HSQLDB option and point BORG to a folder where you would like to keep your data files.

As of BORG 1.6, HSQLDB is the default DB type as it requires no special actions from the user.

MySQL

Using MySQL with BORG requires the user to download at setup the MySQL software. In addition, the user must also download and install a JDBC database driver for MySQL.

Some familiarity with MYSQL is assumed in the instructions below.

To use RDBMS support with MYSQL:

1.Install MYSQL and make it accessible on your machine or network. See www.mysql.com for the software (which is free).

2. Create a database for BORG data in MYSQL. Name it whatever you like.

3. Create a user with at least select/insert/update/delete access to your database

4. Create the BORG database tables in your database. This is done by running the SQL contained in the borg_mysql.sql file that comes with BORG. From the mysql command line you would do this:
mysql>use your-database-name
mysql>source borg_mysql.sql <=== you need the full path to borg_mysql.sql if it is not in your current folder.

5.BORG looks for a database driver for MYSQL in the CLASSPATH. The driver is ** NOT ** shipped with BORG. You have to download and install this separately.

6. Run BORG and set the MySQL database parameters from the database options screen.