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

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

user3208

# Check the default location of secure_file_priv
SHOW VARIABLES LIKE "secure_file_priv";

# Save the file in that location
Select ... From ... INTO OUTFILE ...

Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement

user1600

LOAD DATA LOCAL INFILE ...