Mysql error : Couldn’t execute SQL: LOAD DATA LOCAL INFILE ‘/tmp/fifo’ REPLACE INTO TABLE FIELDS

Couldn't execute SQL: LOAD DATA LOCAL INFILE '/tmp/fifo' REPLACE INTO TABLE FIELDS TERMINATED BY '\t' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\'
MySQL Bulk Loader.0 - The used command is not allowed with this MySQL version
MySQL Bulk Loader.0 –

Execute below steps in mysql and make on value of local_infile variable.

mysql> SHOW GLOBAL VARIABLES LIKE 'local_infile';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| local_infile  | OFF   |
+---------------+-------+
1 row in set (0.00 sec)

mysql> SET GLOBAL local_infile = 'ON';
Query OK, 0 rows affected (0.00 sec)

mysql> commit;
Query OK, 0 rows affected (0.00 sec)

mysql> SHOW GLOBAL VARIABLES LIKE 'local_infile';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| local_infile  | ON    |
+---------------+-------+
1 row in set (0.00 sec)

Mysql error : Couldn’t execute SQL: LOAD DATA LOCAL INFILE ‘/tmp/fifo’ REPLACE INTO TABLE FIELDS

Tags