Upgrade Instructions for Linux Tar Packages

Note: Due to the port to MySQL 5.1 GA, the underlying data structures have changed. Please see step 4 below on how to run the MySQL Updater to migrate your previous database to 3.1.1 during the upgrade. After upgrading to 3.1.1 you will not be able to use a 3.1.1 database with a previous versions of ICE. We recommend you backup your data before upgrading in case you wish to downgrade for any reason.

1. Obtain root user access

2. Unpack the tarball into a temporary folder:

cd /path/to/temp/
gunzip < /path/to/infobright-3.3.1-x86_64.tar.gz | tar xvf -
cd infobright-3.3.1-x86_64

3. Stop the Infobright server:

/etc/init.d/mysqld-ib stop

3. Run the install script with the "--upgrade” and “--config” flags and pass in the configuration files of the previously installed version:

./install-infobright.sh --upgrade --config=/etc/my-ib.cnf

4. Start the Infobright server and run the mysql_upgrade utility:

/etc/init.d/mysqld-ib start
cd /usr/local/infobright
./bin/mysql_upgrade --defaults-file=/etc/my-ib.cnf --user=root --tmpdir=/tmp

Important: The MySQL Upgrade utility may display several errors regarding the use of locks with log tables and errors requiring table upgrades. The errors are all handled automatically by Infobright and/or the upgrade utility and can be ignored.

5. Re-start the Infobright server:

/etc/init.d/mysqld-ib restart

6. Confirm the build version as IB_3.3.1_r6997_7017:

/usr/local/infobright/bin/mysqld --version