In moving a relatively large table from MySQL to Redis, you may find
that extracting, transforming and loading a row at a time can be
excruciatingly slow. Here’s a quick trick you can use that pipes the
output of the mysql command directly to redis-cli, bypassing
middleware and allowing both data stores to operate at their peak
Nice trick. Which by the way was documented on the Redis site. With some more work (worth for larger data sets), you could actually generate a Redis RDB file directly.
Original title and link: Redis Mass Data Import: MySQL to Redis in One Step ( ©myNoSQL)