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

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

Error Code: 1290 Hatasinin cozumu icin asagidaki parametrenin set edilmesi gerekir. Bu parametre ile export yapacaginiz path ‘i belirtiyorsunuz.

SHOW VARIABLES LIKE “secure_file_priv”;

By default path /var/lib/mysql-files/ dir. Ornek export scripti asagida bulabilirsiniz.
SELECT * FROM `performance_sn` LIMIT 100

INTO OUTFILE ‘/var/lib/mysql-files/test.csv’
FIELDS TERMINATED BY ‘,’
ENCLOSED BY ‘”‘
LINES TERMINATED BY ‘\n’;

 

Tayfur Boler

Senior Database Administrator

www.mysqlsupport.net / www.mysqlturkiye.com