將mysql資料匯入到redis

標籤：sel   root   --   sele   不包含   secure   注意   null   extra   

用指令碼類比redis的用戶端redis-cli實現：（註：mysql地址為10.86.30.203 redis地址為10.86.31.50）
1.首先確定mysql表的列：

desc  test；+-----------+-------------+------+-----+---------+-------+| Field     | Type        | Null | Key | Default | Extra |+-----------+-------------+------+-----+---------+-------+| id    | int(11)     | YES  |     | NULL    |       || test1  | varchar(50) | YES  |     | NULL    |       || test2  | varchar(64) | YES  |     | NULL    |       || test3 | int(11)     | YES  |     | NULL    |       |+-----------+-------------+------+-----+---------+-------+4 rows in set (0.00 sec)

2.編寫sql指令碼：

vi /home/darren/test.sqlSELECT CONCAT("*8\r\n",‘$‘, LENGTH(redis_cmd), ‘\r\n‘,redis_cmd, ‘\r\n‘,‘$‘, LENGTH(redis_key), ‘\r\n‘,redis_key, ‘\r\n‘,‘$‘, LENGTH(hkey1), ‘\r\n‘,hkey1, ‘\r\n‘,‘$‘, LENGTH(hval1), ‘\r\n‘, hval1, ‘\r\n‘‘$‘, LENGTH(hkey2), ‘\r\n‘,hkey2, ‘\r\n‘,‘$‘, LENGTH(hval2), ‘\r\n‘, hval2, ‘\r\n‘‘$‘, LENGTH(hkey3), ‘\r\n‘,hkey3, ‘\r\n‘,‘$‘, LENGTH(hval3), ‘\r\n‘, hval3, ‘\r‘)FROM (SELECT‘HMSET‘ AS redis_cmd, CONCAT(‘id:‘,id) AS redis_key,‘test1‘ AS hkey1,test1  AS hval1,‘test2‘ AS hkey2,test2 AS hval2,‘test3‘ AS hkey3,test3 AS hval3 FROM test ) AS t

注意：其中*8的意思是一共有8個參數，$length()為參數的長度。指令碼中test1，test2，test3均為mysql的列名，可自行修改。

3.執行匯入命令：

mysql -uroot -pxxx -h 10.86.30.203 test --skip-column-names --raw < /home/darren/test.sql | redis-cli  --pipe----------------------------------------------------------------------------------------------------------------mysql: [Warning] Using a password on the command line interface can be insecure.All data transferred. Waiting for the last reply...Last reply received from server.errors: 0, replies: 1

出現以上errors為0為匯入成功。

–raw: 使mysql不轉換欄位值中的分行符號。
–skip-column-names: 使mysql輸出的每行中不包含列名。

將mysql資料匯入到redis