maria-discuss team mailing list archive
Mailing list archive
Re: LOAD DATA LOCAL INFILE
local-infile is both a client and a server flag - both must be enabled
or you'll get an error. mysql --local-infile=1 only enables the
client support for this feature. Your MariaDB server likely has this
disabled - perhaps as a security concern.
I would inspect your my.cnf and update the value if you need this
feature. If you have sufficient privileges, you can enable this
dynamically by running:
mysql -e "SET GLOBAL local_infile = on"
On Wed, Feb 15, 2017 at 8:05 AM, Karthick Subramanian
> mysql -u root --local-infile=1
> I missed the double dashes (--). When you try with --, it will accept, but
> as you said it doesn't have any effect on session level.
> I remember I did local infile successfully some 3 months back, but now its
> not working. Not sure what version I used 3 months back. But currently its
> On Wed, Feb 15, 2017 at 7:26 PM, Peter Laursen <peter_laursen@xxxxxxxxxx>
>> According to
>> this variable has GLOBAL scope (and I don-t think mariaDB has changed
>> anything here. The SESSION-scope value is always inherited from the GLOBAL
>> 'local-infile' is also considered a security setting and as such it makes
>> sense IMO that a user cannot change for his SESSION as she likes.
>> Also I get this (on Windows)
>> C:\Program Files\MariaDB 10.2\bin>mysql -u root -p local-infile=1
>> Enter password: ********
>> ERROR 1049 (42000): Unknown database 'local-infile=1'
>> Is it possible to specify a server variable on the commandline at all? I
>> don't think so. At least I never heard about it.
>> -- Peter
>> -- Webyog
>> On Wed, Feb 15, 2017 at 2:43 PM, Karthick Subramanian
>> <ksubramanian@xxxxxxxxxxxxxxx> wrote:
>>> 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
>>> 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.
>>> Mailing list: https://launchpad.net/~maria-discuss
>>> Post to : maria-discuss@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~maria-discuss
>>> More help : https://help.launchpad.net/ListHelp
> Mailing list: https://launchpad.net/~maria-discuss
> Post to : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help : https://help.launchpad.net/ListHelp