phpmyadmin and LOAD DATA LOCAL

[harvillo]

Major problems with file uploads with latest MySQL release. I've read the doc at mysql.com regarding the issue and have added the local local-infile[=1] to my.cnf. I've seen others with this problem and have not been able to rectify the dilemma on my end. And advice would be greatly appreciated. BTW all other areas of MySQL are working perfectly on this Linux web server.

[nnichols]

I think the problem is not with mysql, but with your understanding of the command.

'LOCAL' makes the client do the file finding whereas without 'LOCAL' the server does the locating of the file. This is so that you can use a remote client to load data.

You need to either run the same command on a local client or run it without 'LOCAL' after uploading the file to the remote server.

Hope this helps 😉