|
1.
create user 'b1'@'localhost' identified by 'b1';
grant all privileges on *.* to 'b1'@'localhost' identified by 'b1';
2.
select oid into outfile '/home/brian/xxx.csv' from android_user_event_sorted;
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
secure_file_priv设置了指定目录，需要在指定的目录下进行数据导出
show variables like '%secure%';
+--------------------------+-----------------------+
| Variable_name??????????? | Value???????????????? |
+--------------------------+-----------------------+
| require_secure_transport | OFF?????????????????? |
| secure_auth????????????? | ON??????????????????? |
| secure_file_priv???????? | /var/lib/mysql-files/ |
+--------------------------+-----------------------+
select oid into outfile '/var/lib/mysql-files/xxx.csv' from android_user_event_sorted;
select oid,userid,createtime,method,page into outfile '/var/lib/mysql-files/page_event.csv' fields terminated by '|' lines terminated by 'n' from an_user_event;
3. 这一点很重要，如果找不到资料，要在这里折腾很久。
（编辑：晋中站长网）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
