这个博客主要介绍了如何使用Shell脚本从MySQL数据库中导出表格为CSV文件。脚本首先获取数据库的表名，然后通过`mysqldump`命令将每个表的数据保存为CSV格式。此外，还展示了如何处理包含特殊字符如单引号的行，并对特定表格进行了单独的导出操作。
#!/bin/bash
DB-csv出力
schema=insvjsk_cmn
cred="-h xxxx.cluster-crfum7txw65z.ap-northeast-1.rds.amazonaws.com ${schema} -u -p"
mapfile result < <(mysql ${cred} -se “SHOW TABLES FROM insvjsk_cmn;”)
path=/home/ec2-user/20190116/100/
for row in “
r
e
s
u
l
t
[
@
]
"
;
d
o
n
a
m
e
=
"
{result[@]}";do name="
result[@]";doname="{path}${row}”
name=echo ${name}
mysqldump ${cred} ${row} > ${name}.csv
done
#!/bin/bash
#单一DB出力
cred="-h xxxx·rfum7txw65z.ap-northeast-1.rds.amazonaws.com insvjsk_maker -u -p"
selMdbMst=$(cat << EOS
SELECT
FROM
INSVJSK_CMN.WHS_CUSTOMER_MST
EOS
)
mysql c r e d − e " cred -e " cred−e"selMdbMst" | sed ‘s/\t/","/g;s/^/"/;s/$/"/;s/\n//g’ | nkf -x --overwrite --oc=UTF-8-BOM > /home/ec2-user/20190116/WHS_CUSTOMER_MST.csv
#!/bin/bash
#单引号删除
path=/home/ec2-user/20190116/100/
cat
p
a
t
h
"
.
c
s
v
"
∣
w
h
i
l
e
r
e
a
d
l
i
n
e
d
o
e
c
h
o
"
{path}".csv" | while read line do echo "
path".csv"∣whilereadlinedoecho"{line}"
done
扫一扫
53
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
