MySQL Forums
Forum List  »  General

issue with secure-file-priv
Posted by: Muhammad Ali
Date: December 04, 2017 09:32AM

I am using MySQL version is 5.7.13 on CentOS release 6.7 and facing issue with SELECT ... INTO DUMPFILE as follows

/usr/bin/mysql --login-path=local MyDB -se "CALL _MyProc(@Result);SELECT @Result INTO DUMPFILE '/tmp/mysql/TempFile.txt';"
ERROR 1290 (HY000) at line 1: The MySQL server is running with the --secure-file-priv option so it cannot execute this statement

However following command works fine

/usr/bin/mysql --login-path=local MyDB -se "CALL _MyProc(@Result);SELECT @Result INTO DUMPFILE '/tmp/TempFile.txt';"

My.cnf file has entry as secure-file-priv="/"

Seems like MySQL is not able to write into sub-directories on secure-file-priv

Please help me to resolve the issue

Options: ReplyQuote


Subject
Written By
Posted
issue with secure-file-priv
December 04, 2017 09:32AM
December 04, 2017 10:50AM
December 09, 2017 02:54PM
December 12, 2017 07:42AM
December 13, 2017 08:24AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.