shell导出mysql到mongo

发布时间：2020-12-15 09:25:43 所属栏目：安全来源：网络整理

导读：# mysql导出tsv格式文件mysql -hlocalhost -uUSER -pPASSWORD -e " select id,name,age,sex from DB_NAME.users where age 10 into outfile '/tmp/xxxx.tsv' fields terminated by 't' optionally enclosed by '' escaped by '' lines terminated by 'rn'

# mysql导出tsv格式文件

mysql -hlocalhost -uUSER -pPASSWORD -e "select id,name,age,sex from DB_NAME.users where age>10 into outfile '/tmp/xxxx.tsv' fields terminated by 't' optionally enclosed by '' escaped by '' lines terminated by 'rn';"

#mongoimport 把tsv文件数据导入mongodb

mongoimport -h localhost -u USER -p PASSWORD -d DB_NAME -c user_collection --columnsHaveTypes --type tsv --file '/tmp/xxxx.tsv' -f id.int(),name.string(),age.int(),sex.int(),created_date.date_ms('yyyy-MM-dd H:mm:ss')

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!