Note: To make it easier to run MySQL and Infobright co-resident on the same server, ICE 3.1 changes the install location to /infobright from /mysql in version 3.0, and adds the suffix -ib to startup scripts and wrappers located in /etc/init.d/mysqld-ib and /usr/bin/mysql-ib (i.e., mysqld-ib) to avoid conflicts. Therefore, it is advised to perform a fresh install ICE 3.1, then copy your existing data directory into the new install location:

<u>Upgrade instructions:</u>

1. Obtain root user access

2. Stop the Infobright server:

/usr/local/mysql/bin/mysqladmin --defaults-file=/etc/my.cnf -uroot shutdown

3. Install ICE 3.1 (see Install Guide)

4. Copy the database files to the infobright install directory, with the exception of the brighthouse.ini file:

cd /usr/local/mysql/data
ls | grep -v brighthouse.ini | xargs -I xxx cp -Rf xxx /usr/local/infobright/data

5. Change the ownership to mysql on the data directory:

cd /usr/local/infobright
chown –R mysql.mysql data

6. Edit the newly installed brighthouse.ini file to match any previously changed settings (i.e., adjusting the memory size, setting ControlMessage level, etc.)

7. Start the ICE server:

/etc/init.d/mysqld-ib start

8. Confirm the build version as IB_3.1_r3027_3069:

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