Transfer data from Redis to MySQL in a few clicks

by

Posted on by

Want to transfer data from Redis to MySQL without programming?

Using RedisDataStudio, a native GUI tool, you can transfer data from Redis to MySQL (MariaDB, Percona) easily and fast, just a few mouse clicks!

Support Windows, Linux, macOS.

Transfer data from Redis To MySQL (MariaDB, Percona)

Log in to Redis.

Move data from Redis To MySQL (MariaDB, Percona) - log in to Redis

Log in to MySQL database.

Transfer data from Redis To MySQL (MariaDB, Percona) - Choose MySQL and logon

1. You can transfer data from a Redis hash key to MySQL (MariaDB, Percona) table.

For example, a redis hash key “users”, store each record as a JSON string.

Key Field Value
users
1 {“name”:”Fred”,”age”:25}
2 {“name”:”Tom”,”age”:28}

2. You can transfer data from Redis hash keys to MySQL (MariaDB, Percona) table.

For example, 2 redis hash keys “user:1” and “user:2”, each store a record, and each field of the record as a Redis hash key’s field.

Key Field Value
user:1
name Fred
age 25
user:2
name Tom
age 28

3. You can transfer data from Redis string keys to MySQL (MariaDB, Percona) table.

For example, 2 redis string keys “user:1” and “user:2”, each store record as JSON-encoded string.

Key Value
user:1 {“name”:”Fred”,”age”:25}
user:2 {“name”:”Tom”,”age”:28}

All above 3 cases, data will store in a MySQL (MariaDB, Percona) table “users”.

id name age
1 Fred 25
2 Tom 28

Transfer data from Redis to MySQL (MariaDB, Percona).

Convert data from Redis To MySQL (MariaDB, Percona) - transfer

Here you can Download RedisDataStudio