一步完成 MySQL 向 Redis 迁移

[test]> select * from hechunyang;

+----+--------+---------+

| id | myname | mymoney |

+----+--------+---------+

|  1 | aa     |    1000 |

|  2 | bb     |    2000 |

+----+--------+---------+

2 rows in set (0.00 sec)

cat mysql_to_redis.sql

SELECT CONCAT(

  "*4rn",

  '$', LENGTH(redis_cmd), 'rn',

  redis_cmd, 'rn',

  '$', LENGTH(redis_key), 'rn',

  redis_key, 'rn',

  '$', LENGTH(hkey), 'rn',

  hkey, 'rn',

  '$', LENGTH(hval), 'rn',

  hval, 'r'

)

FROM (

  SELECT

  'HSET' AS redis_cmd,

  'keyname' AS redis_key,

  myname AS hkey,

  mymoney AS hval

  FROM hechunyang

) AS t;

mysql test --skip-column-names --raw < mysql_to_redis.sql | redis-cli --pipe

All data transferred. Waiting for the last reply...

Last reply received from server.

errors: 0, replies: 2

127.0.0.1:6379> keys *

1) "keyname"

127.0.0.1:6379> hkeys keyname

1) "aa"

2) "bb"

127.0.0.1:6379> hget keyname aa

"1000"

127.0.0.1:6379> hget keyname bb

"2000"