Want to transfer data from MySQL to Redis without programming?
Using RedisDataStudio, a native GUI tool, you can transfer data from MySQL (MariaDB, Percona) to Redis easily and fast, just a few mouse clicks!
Support Windows, Linux, macOS.
Transfer data from MySQL (MariaDB, Percona) To Redis
Log in to MySQL database.
Log in to Redis.
You can transfer data from MySQL (MariaDB, Percona) table or sql query results to Redis, in 3 formats.
For example, you have a MySQL (MariaDB, Percona) table “users”, 2 records in it.
| id | name | age |
| 1 | Fred | 25 |
| 2 | Tom | 28 |
1. Store a record as JSON-encoded string in a single key.
| Key | Value |
| user:1 | {“name”:”Fred”,”age”:25} |
| user:2 | {“name”:”Tom”,”age”:28} |
2. Store a record as a Redis hash key, 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. Store each record as a JSON string in a Redis hash.
| Key | Field | Value |
| users | ||
| 1 | {“name”:”Fred”,”age”:25} | |
| 2 | {“name”:”Tom”,”age”:28} |
Transfer data from MySQL (MariaDB, Percona) to Redis.
Here you can Download RedisDataStudio
