How to import dumb.rdb file on redis and export to mysql database

Question

RDB files of REDIS servers imported from other servers. I have installed REDIS on my local machine and am trying to import it to my local REDIS server. Mainly I want to store all REDIS data in mysql database. Is there any direct process to import DUMB.RBD file to mysql database. Is there any other process to import REDIS data into CSV format. Any help would be very helpful to me.

P粉178132828 · Answer

Redis is a schema-less key-value NOSQL database. There aren't any built-in solutions for moving data from Redis to a SQL database or CSV file. But you can write some code yourself to do this:

Use SCAN to get all keys in the Redis instance.
Getting their values depends on the key type (can be determined by TYPE).
Write SQL.

P粉817354783 · Answer

Get answers with Node js and Redis.

For the import, I used the following command after shutting down the redis server

sudo cp /var/dump.rdb /home/etc/redis/dump.rdb

Use Nodejs to parse Redis data and connect to mysql at the same time.

var mysql      = require('mysql');
var connection = mysql.createConnection({
host              : 'localhost',
port              : '3306',
database          : 'db',
user              : 'root',
password          : 'password',
insecureAuth      : true,
multipleStatements: true
});
var post  = {name: practice.name, practiceId: practice.id,type: practice.wid};
var query = connection.query('INSERT INTO  facilities SET ?', post, function(err, result) { });

                console.log(query.sql +';');