[Bio-Linux] Problems with MySQL local infile

[Lehtovirta, Laura Elina]

Hi,



I'm having a problem with loading data into MySQL using LOAD DATA LOCAL INFILE. The error I'm getting is "The used command is not allowed with this MySQL version". I've tried "--local-infile" when starting MySQL and modified the my.cnf file to contain "local-infile=1".

Command "SHOW GLOBAL VARIABLES LIKE 'local_infile';" shows that local infile is on but does not get rid of the error. I'm using MySQL version 14.14 Distrib 5.5.44, for debian-linux-gnu (x86_64) using readline 6.3. Does anyone have suggestions how to fix this?



Many thanks in advance,



Laura

Dr Laura Lehtovirta-Morley
Postdoctoral Research Associate
Institute of Biological and Environmental Sciences
Cruickshank Building
University of Aberdeen
St Machar Drive
Aberdeen
AB24 3UU



The University of Aberdeen is a charity registered in Scotland, No SC013683.
Tha Oilthigh Obar Dheathain na charthannas cl?raichte ann an Alba, ?ir. SC013683.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.bioinformatics.org/pipermail/bio-linux-list/attachments/20151006/2b94b061/attachment.html>