MySQL导出CSV格式解决乱码原创
# mysql 导出csv格式数据解决乱码
导出csv
方法一
root@95d956bb2012:/# mysql -u root -p -e "select * from wordpress.wp_users" |sed 's/\t/","/g;s/^/"/;s/$/"/;s/\n//g' > /tmp/wp_users.csv
1
方法二
SELECT * INTO OUTFILE '/data/db/mysql3306/filedir/a.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM wordpress.wp_users;
1
/data/db/mysql3306/filedir/该路径是mysql
配置文件my.cnf
中指定的唯一导出目录,secure_file_priv
的位置,若没有设置,则指定/tmp/即可
secure_file_priv = /data/db/mysql6633/filedir
1
解决中文乱码
sed -i '1s/^/\xEF\xBB\xBF/' /tmp/wp_users.csv
1
上次更新: 12/20/2024
- 01
- Logstash迁移ES数据12-11
- 02
- Elastichsearch使用wildcard字段模糊匹配12-07