The reason this is significant is because we are speaking about INFILE use. The server processes infile commands assuming the file is already stored on the server. LOCAL INFILE tells mysql that file is local to the mysql client and must be moved to the server before processing. I suspect that this has been your issue all along.
On 2012-10-18 1:37 PM, "kalin" <ka...@el.net> wrote: not sure i follow. what do you mean connect?! there is a server (mysqld) and a client (mysql). the client gets to the server via the socket. like on any other unix machine. how did i connect mysql to what exactly? On 10/18/12 6:42 AM, Ananda Kumar wrote: > > > > how did u connect mysql on your laptop > > > > On Thu, Oct 18, 2012 at 1:19 AM, kalin <ka...@el.net > > > <mailto:ka...@el.net>> wrote: > > > > > > thanks amanda... the "local" worked for some reason... > > > ... > > > <mailto:anan...@gmail.com <mailto:anan...@gmail.com>>> wrote: > > > > does both d... > <mailto:rja...@yahoo-inc.com > > > > <mailto:rja...@yahoo-inc.com>>> wrote: > > > > SELinux ? > > > > ... > > > <mailto:mysql@lists.mysql.com > > <mailto:mysql@lists.mysql.com>> > > ... > > > <mailto:ka...@el.net <mailto:ka...@el.net>>> wrote: > > > > > ... > <mailto:pengli...@gmail.com > > > > <mailto:pengli...@gmail.com>>> wrote: > > > >> > > > >> H... > > > <mailto:ka...@el.net <mailto:ka...@el.net>>> wrote: > > > >> > > ... >