从mysql中导出数据
-
查看MySQL的数据存储路径
show variables like “secure_file_priv”;
默认是/var/lib/mysql-files -
在数据存储路径下创建独立的文件夹用于存放导出的数据
mkdir -p {/var/lib/mysql-files}/retail_db
chmod 777 -R /var/lib/mysql-files/retail_db
-
导出数据
-
customer表
select * from customers into outfile '/var/lib/mysql-files/retail_db/customers.csv' fields terminated by ',' enclosed by '"' lines terminated by '\n';
-