Mysql Workbench configuration
Budget: £10 – £20 GBP
Hello,
I'm getting an error in Mysql Workbench with the following error:
10:44:43 SELECT * INTO OUTFILE '/usr/local/mysql/data/dump.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM shopify.LS_Import_Before_Type_Change WHERE tags like ('%Category_%') Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement 0.00096 sec
Load data local infile works fine.
SHOW VARIABLES LIKE "secure_file_priv"; is NULL
Can you help with configuration?
I'm getting an error in Mysql Workbench with the following error:
10:44:43 SELECT * INTO OUTFILE '/usr/local/mysql/data/dump.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM shopify.LS_Import_Before_Type_Change WHERE tags like ('%Category_%') Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement 0.00096 sec
Load data local infile works fine.
SHOW VARIABLES LIKE "secure_file_priv"; is NULL
Can you help with configuration?