redis导数到mysql

Posted on 2018-08-10 15:49  打杂滴  阅读(261)  评论(0编辑  收藏  举报

filename=$(date "+%Y%m%d%H%M%S")

//将type为list,键为bi0205导出文本,并保存到mysql导入导出目录
redis-cli -h 服务器IP -p port -a username@password "bi0205" 1 10000000 >>/var/lib/mysql-files/loginfo_$filename.txt

//将导出的文件导入mysql
mysql -uroot -ppasword -e "load data infile \"/var/lib/mysql-files/loginfo_$filename.txt\" into table dbname.loginfo_1;"

//根据需要进行处理
mysql -uroot -ppassword -e "call dbname.elt_loginfo()"

//删除从redis导出的数据文件
rm /var/lib/mysql-files/loginfo_$filename.txt

Copyright © 2024 打杂滴
Powered by .NET 8.0 on Kubernetes