Shulou(Shulou.com)06/01 Report--

Mysql has permission restrictions on exported directories by default, that is, when using the command line for export, you need to specify a directory to operate.

Mysql > select * from T1 into outfile'/ tmp/t1_mysql.csv' fields terminated by ","

ERROR 1290 (HY000): The MySQL server is running with the-- secure-file-priv option so it cannot execute this statement

Solution:

1. Query what is configured for the secure_file_priv value of mysql

[mysqld]

Secure-file-priv=/var/lib/mysql

[root@localhost ~] # systemctl restart mysqld

[root@localhost] # mysql-u root

two。 Start exporting using into outfile: because of the secure_file_priv configuration, you must export to the / var/lib/mysql/ directory

Mysql > select * from T1 into outfile'/ var/lib/mysql/t1_mysql.csv' fields terminated by "," OPTIONALLY ENCLOSED BY "" 'LINES TERMINATED BY'\ n'

3. Keyword interpretation: because the exported data will appear some garbled or special characters, so use the above keywords for escape

FIELDS TERMINATED BY', 'OPTIONALLY ENCLOSED BY' "'LINES TERMINATED BY'\ n'

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.