MySQL Forums
Forum List  »  General

Advanced Search
New Topic

Re: Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
Posted by: JK Heydt
Date: August 24, 2020 06:02AM

LOAD DATA LOCAL INFILE 'C:\ProgramData\MySQL\MySQL Server 8.0\Uploads\trn_cd.tsv' INTO TABLE a_trn_cde
IGNORE 1 ROWS;

I also changed SHOW GLOBAL VARIABLES LIKE 'local_infile' and 'local_infile', 'ON'

Now the error is:


Error Code: 3948. Loading local data is disabled; this must be enabled on both the client and server sides

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
JK Heydt
August 23, 2020 06:50PM
Re: Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
Peter Brawley
August 23, 2020 07:54PM
Re: Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
JK Heydt
August 24, 2020 06:02AM
Re: Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
Peter Brawley
August 24, 2020 10:17AM
Re: Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
JK Heydt
August 24, 2020 10:27AM
Re: Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
Peter Brawley
August 24, 2020 03:35PM
Re: Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
JK Heydt
August 25, 2020 06:15AM
Re: Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
Peter Brawley
August 25, 2020 01:36PM
Re: Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
JK Heydt
August 25, 2020 03:12PM
Re: Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
JK Heydt
August 24, 2020 05:40AM


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.