Installing and Upgrading the Database

From DLXS Documentation

Revision as of 12:39, 12 August 2008

Main Page > Installing DLXS > Installing and Upgrading the Database

For brand new DLXS middleware installations, create a new MySQL database following these instructions:

MySQL configuration

For DLXS installations you will use MySQL as your data store. You should execute the following commands to create an empty database, user accounts, and access permissions required for use with DLXS middleware.

1. Start the SQL monitor with the command mysql -u root -p mysql (you will be prompted for the MySQL system password).
2. Create the DLXS database with the command create database dlxs;. Note that you should use the database name you chose when prompted for the name of the database during DLXS middleware installation rather than simply dlxs. We suggest you should choose a name that reflects the version number of the database delivered with the middleware release or perhaps the release number of the middleware.
3. Create the dlxsadm (administrative) account and grant full privileges to it with the command grant all privileges on dlxs.* to dlxsadm identified by 'password';, where password is the password to be used for DLXS database administration.
4. Grant FILE privilege to the dlxsadm account with the command grant file on *.* to dlxsadm;.
5. Create the dlxs account and grant basic privileges to it with the command grant select,insert,update,delete,references on dlxs.* to dlxs identified by 'password';, where password is the password to be used for general DLXS database usage (such as from within the DLXS middleware).
6. Activate the changes with the command flush privileges;.
7. Exit the SQL monitor with the command quit.

After the database is created, the next step is to install the sample database data contained in $DLXSROOT/misc/db/db-dump-vN.0-release.sql where N is the version of the database that corresponds to the release of DLXS.

Let dlxs_vN be the database name you chose for this installation. Note that this is the database name you supplied at the prompt when you ran the Installer. Use the mysql command line client to load the dump file like this:

  % mysql -u dlxsadm -p dlxs_vN < $DLXSROOT/misc/db/db-dump-vN.0-release.sql

That's it!

Database upgrading

NOTE: This topic is also discussed in DLXS Database Upgrade Utility.

If you already have a DLXS database set up for an earlier release, make a copy of it and then upgrade the copy to support the newly installed DLXS release.

Let's say your current database is named dlxs_v5 and the new database will be named dlxs_v6. To make a copy of your current MySQL database and upgrade it:

Step 1

dump dlxs_v5 using

% mysqldump -u dlxsadm -p dlxs_v5 > dlxs_v5_dump.sql

Step 2

create an empty dlxs_v6 database as described above in MySQL configuration

Step 3

load dlxs_v5_dump.sql into dlxs_v6

% mysql -u dlxsadm -p dlxs_v6 < dlxs_v5_dump.sql

Step 4

upgrade the copy of dlxs_v5 that you loaded into dlxs_v6

% $DLXSROOT/bin/db/upgrade_5_6

IMPORTANT NOTE

In the upgrade process, in your shell, $DLXSROOT must always be the root of the new DLXS release 13 (or latest) installation. All previous upgrade_* scripts are included with each DLXS release. In this case, this means upgrade_5_6 will act on the database name you supplied when you installed release 13.

Upgrading across multiple database versions

If your existing database version is more than one version behind 6, run the $DLXSROOT/bin/db/upgrade_* scripts sequentially on the new database containing the dump of the earlier database version.

For example, if you copied dlxs_v3 into dlxs_v6 you would run, in order: $DLXSROOT/bin/db/upgrade_3_4, $DLXSROOT/bin/db/upgrade_4_5 and finally $DLXSROOT/bin/db/upgrade_5_6 all from the release 13 (or latest) install tree.

% mkdir -p $DLXSROOT/misc/db/ImageClassSampleData/version5

Download the following file from the DLXS web site and copy it into that directory: http://www.dlxs.org/products/archive-by-CDROM/13/Lib/src/misc/db/ImageClassSampleData/version5/icsample.sql </font>

For reference here are the DLXS release numbers and their corresponding database version numbers:

Top