IEE資料庫安裝嚮導

IEE資料庫安裝嚮導

RHEL 5用rpm包，直接安裝後配置資料及緩衝目錄即可。

RHEL 6用tar包+設定檔，本文是在RHEL 6上安裝IEE的嚮導。

①上傳infobright-4.0.6-x86_64.tar包和設定檔my-ib.cnf，mysqld-ib到伺服器任意目錄②解壓tar包，移動到/usr/local/目錄下，設定檔分別移動到/etc/目錄，/etc/init.d/目錄下

tar -xvf infobright-4.0.6-x86_64.tarmv infobright-4.0.6-x86_64 /usr/local/mv my-ib.cnf /etc/mv mysqld-ib /etc/init.d/chmod u+x /etc/init.d/mysqld-ib

③啟動IEE服務，關閉IEE服務

--啟動IEE服務/etc/init.d/mysqld-ib start--關閉IEE服務/etc/init.d/mysqld-ib stop

④建立進入IEE資料庫命令列介面的捷徑mysql-ib

ln -s /usr/local/infobright-4.0.6-x86_64/bin/mysql /usr/local/bin/mysql-ib 

⑤配置更改IEE資料庫的資料目錄和緩衝目錄（IEE服務是關閉狀態時操作）# pwd（切到軟體目錄）

/usr/local/infobright-4.0.6-x86_64

# ./postconfig.sh（第一次運行postconfig.sh,更改IEE資料庫的資料目錄） 

Infobright post configuration--------------------------------------Using postconfig you can:--------------------------------------(1) Move existing data directory to other location,(2) Move existing cache directory to other location,(3) Configure server socket,(4) Configure server port,(5) Relocate datadir path to an existing data directory.Please type 'y' for option that you want or press ctrl+c for exit.Current configuration:--------------------------------------Current config file: [/etc/my-ib.cnf]Current brighthouse.ini file: [/usr/local/infobright-4.0.6-x86_64/data/brighthouse.ini]Current datadir: [/usr/local/infobright-4.0.6-x86_64/data]Current CacheFolder in brighthouse.ini file: [/usr/local/infobright-4.0.6-x86_64/cache]Current socket: [/tmp/mysql-ib.sock]Current port: [5029]--------------------------------------(1) Do you want to copy current datadir [/usr/local/infobright-4.0.6-x86_64/data] to a new location? [y/n]:yGive new datadir path (e.g. /opt/datadirnewpath/data):/ieedata/data(2) Option to change CacheFolder is disabled when option 1 is chosen!(3) Do you want to change current socket [/tmp/mysql-ib.sock]? [y/n]:n(4) Do you want to change current port [5029]? [y/n]:n(5) Relocation is disabled when options 1-4 are chosen!--------------------------------------Datadir(/usr/local/infobright-4.0.6-x86_64/data) is going to be copied to /ieedata/data--------------------------------------Please confirm to proceed? [y/n]:yCopying /usr/local/infobright-4.0.6-x86_64/data to /ieedata/data ...is done.You can now remove/backup your old /usr/local/infobright-4.0.6-x86_64/data ...Done!

 # ./postconfig.sh（第二次運行postconfig.sh,更改IEE資料庫的cache目錄）
 

Infobright post configuration--------------------------------------Using postconfig you can:--------------------------------------(1) Move existing data directory to other location,(2) Move existing cache directory to other location,(3) Configure server socket,(4) Configure server port,(5) Relocate datadir path to an existing data directory.Please type 'y' for option that you want or press ctrl+c for exit.Current configuration:--------------------------------------Current config file: [/etc/my-ib.cnf]Current brighthouse.ini file: [/ieedata/data/brighthouse.ini]Current datadir: [/ieedata/data]Current CacheFolder in brighthouse.ini file: [/usr/local/infobright-4.0.6-x86_64/cache]Current socket: [/tmp/mysql-ib.sock]Current port: [5029]--------------------------------------(1) Do you want to copy current datadir [/ieedata/data] to a new location? [y/n]:n(2) Do you want to move current CacheFolder [/usr/local/infobright-4.0.6-x86_64/cache] to a new location? [y/n]:y Give new CacheFolder path:/ieedata/cache(3) Do you want to change current socket [/tmp/mysql-ib.sock]? [y/n]:n(4) Do you want to change current port [5029]? [y/n]:n(5) Relocation is disabled when options 1-4 are chosen!--------------------------------------New CacheFolder is going to be /ieedata/cache--------------------------------------Please confirm to proceed? [y/n]:yCreating new cachedir /ieedata/cache ...is done.Done!

⑥啟動IEE服務，進入資料庫命令列，賦予IEE資料庫的root使用者所有許可權，密碼初始化為123456# /etc/init.d/mysqld-ib start# mysql-ib

Welcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 3Server version: 5.1.40 build number (revision)=IB_4.0.6_r16086_16275(iee - commercial) (static)Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> grant all privileges on *.* to 'root'@'%' identified by '123456'  WITH GRANT OPTION;Query OK, 0 rows affected (0.00 sec)mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)mysql> 

⑦使用者利用navicate工具串連到IEE資料庫，進行建庫建表，字元集的選擇utf-8：

character set : utf8 -- UTF-8 Unicodecollation : utf8_bin

本文永久更新連結地址：