MySQL数据导入Redis

最新推荐文章于 2022-05-04 18:27:13 发布

qq591840685

最新推荐文章于 2022-05-04 18:27:13 发布

阅读量449

点赞数

本文链接：https://blog.csdn.net/qq591840685/article/details/53332763

版权

参考资料：

http://www.ttlsa.com/database/mysql_data_will_be_migrated_to_redis/http://blog.csdn.net/stubborn_cow/article/details/51190785

MySQL数据导入Redis

http://www.ttlsa.com/database/mysql_data_will_be_migrated_to_redis/ 从MySQL中将数据导入到Redis的

http://blog.csdn.net/desilting/article/details/38563087 mysql 多个字段拼接

1. 保证mysql有表：events_all_time 这个就是mysql要传递的数据表

CREATE TABLE events_all_time (
  id int(11) unsigned NOT NULL AUTO_INCREMENT,
  action varchar(255) NOT NULL,
  count int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (id),
  UNIQUE KEY uniq_action (action)
);

2.自己编写一个111.sql文件把他传到 /home/111.sql 这个路径下面

SELECT CONCAT(
  "*4\r\n",
  '$', LENGTH(redis_cmd), '\r\n',
  redis_cmd, '\r\n',
  '$', LENGTH(redis_key), '\r\n',
  redis_key, '\r\n',
  '$', LENGTH(hkey), '\r\n',
  hkey, '\r\n',
  '$', LENGTH(hval), '\r\n',
  hval, '\r'
)
FROM (
  SELECT
  'HSET' as redis_cmd,
  concat('events_all_time:',action) AS redis_key,
  'action' AS hkey,
  count AS hval
  FROM events_all_time
) AS t

mysql -u**** -p********  **** --skip-column-names --raw < /home/111.sql | /usr/local/redis/bin/redis-cli --pipe

第一个：-u****代表mysql帐号

第二个：-p 代表mysql密码

第三个：**** 代表数据库 db的名字，比如admin

执行上述，然后就可以看到导入成功了，用redis desktop mananger就可以看到了

hmset链接：http://www.cnblogs.com/kgdxpr/p/3643672.html

SELECT CONCAT(
"*16\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\n'
'$', LENGTH(hkey4), '\r\n',hkey4, '\r\n','$', LENGTH(hval4), '\r\n', hval4, '\r\n'
'$', LENGTH(hkey5), '\r\n',hkey5, '\r\n','$', LENGTH(hval5), '\r\n', hval5, '\r\n'
'$', LENGTH(hkey6), '\r\n',hkey6, '\r\n','$', LENGTH(hval6), '\r\n', hval6, '\r\n'
'$', LENGTH(hkey7), '\r\n',hkey7, '\r\n','$', LENGTH(hval7), '\r\n', hval7, '\r'
)
FROM (
 SELECT
'HMSET' AS redis_cmd, CONCAT(resource_id,'_hash') AS redis_key,
'name' AS hkey1,resource_title  AS hval1,
'type' AS hkey2,resource_type_name AS hval2,
'exe' AS hkey3,resource_format AS hval3,
'page' AS hkey4,resource_page AS hval4,
'size' AS hkey5,resource_size AS hval5,
'time' AS hkey6,create_time AS hval6,
'num' AS hkey7,resource_downcount AS hval7
 FROM t_resource_info
 ) AS t