infobright 安装到创建数据表到导入数据

cd /etc/init.d
./mysqld-ib stop
./mysqld-ib start

cd /etc/init.d
./iptables stop

-------------
1.下载地址
http://www.infobright.org/downloads/ice/infobright-4.0.7-0-win_32-ice.zip

2.解压直接安装

3.进入Infobright command line client

4.创建本地权限用户
mysql>GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' IDENTIFIED BY '12345678';
mysql>GRANT ALL PRIVILEGES ON *.* TO 'admin'@'127.0.0.1' IDENTIFIED BY '12345678';
mysql>GRANT ALL PRIVILEGES ON *.* TO 'admin'@'%' IDENTIFIED BY '12345678';

5,创建数据库及表
mysql> CREATE TABLE `dim_ec_browser` (
    ->   `browser_id` varchar(100) DEFAULT NULL,
    ->   `browser` varchar(100) DEFAULT NULL
    -> ) ENGINE=BRIGHTHOUSE DEFAULT CHARSET=utf8
    -> ;

6.用户名admin,密码12345678 端口:5209

7.进入步骤3，选定创建表的数据库，LOAD DATA LOCAL INFILE 'E:\dim_ec_browser.txt' INTO TABLE dim_ec_browser  FIELDS TERMINATED BY '\t'
数据记得用Tab分开：
14CB9A628D490C77 TheWorld
40FB033B2B4B3261 Camino
451AC36CB977E719 Chrome
E1F798868A97669F Chrome
C82D301232E3E4B7 Maxthon

8.将数据导出至文件：
select * from $t10 into outfile '/data/bae/mysql_export/$t10.txt'
fields terminated by '\t' enclosed by '"' lines terminated by '\n';

9.从远程mysql 备份数据到本地
mysql -utest -ptest -h192.168.32.87 -P3308 -e "SELECT account,siteName,advertiserName,incomeMoney,createDate FROM ifm_cps.AD_DAY_SUM WHERE createDate = '20130425'" > /tmp/urfile