← Back to team overview

maria-discuss team mailing list archive

LOAD DATA LOCAL INFILE

 

HI All,

Even after enabling --local-infile=1 at mysql user login, I couldn't load
the file locally.

mysql -u root --local-infile=1

LOAD DATA LOCAL INFILE

ERROR 1148 (42000): The used command is not allowed with this MariaDB
version

show variables like '%local%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| local_infile  | OFF   |
+---------------+-------+

Even though i enable --local-infile=1, the local-infile still shows OFF.

Pleaselet know how can I fix this.

Follow ups