Getting into a support type role with some developers using MySQL. One particular developer wanted to use the "LOAD DATA INFILE..." command to load some data from a text file.
I think to myself, "No problem, just grant the FILE privilege".
He tells me "LOAD DATA INFILE" still doesn't work. After a little head-scratching, I pull out MySQL by Paul DuBois and realize it only works from the server and not from the client. Doh. (Although the "Access denied" error was pointing me to the MySQL maze known as privileges).
Subscribe to:
Post Comments (Atom)
3 comments:
Take a look at LOAD DATA LOCAL:
http://dev.mysql.com/doc/refman/5.0/en/load-data-local.html
Allows for a file on the client machine to be loaded.
Thanks for the tip, I need to investigate. I'm not really keen on letting users on the server itself, so this could come in handy.
last comment deleted, spammer.
Post a Comment