infobright与mysql同步_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)