mysql数据导入到infobright

1 在mysql数据库上创建了表
CREATE TABLE `t_mis` (
    -> `uid` mediumint(9) NOT NULL,
    -> `cid` smallint(6) NOT NULL,
    -> `rating` tinyint(4) NOT NULL
    -> ) ENGINE=MyISAM
    -> ;
并插入数据：mysql> insert into t_mis (70000,3600,5),(80000,3700,2);

2 然后将数据导出CSV文件：
SELECT * from t_mis INTO OUTFILE '/tmp/mytable.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';

3 在infobright上创建表
CREATE TABLE `t_ib` (
`uid` mediumint(9) NOT NULL,
`cid` smallint(6) NOT NULL,
`rating` tinyint(4) NOT NULL
) ENGINE=BRIGHTHOUSE;

开启 /etc/init.d/mysqld-ib start

4 导入CSV到表t_ib：
LOAD DATA INFILE '/tmp/mytable.csv' INTO TABLE t_ib FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';

mysql> LOAD DATA INFILE '/tmp/mytable.csv' INTO TABLE t_ib FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';
Query OK, 2 rows affected (4.26 sec)
Records: 2 Deleted: 0 Skipped: 0 Warnings: 0

mysql> select * from t_ib;
+-------+------+--------+
| uid   | cid | rating |
+-------+------+--------+
| 70000 | 3600 |      5 |
| 80000 | 3700 |      2 |
+-------+------+--------+
2 rows in set (0.23 sec)