Dave Fogle writes:
> Thanks for reading this - I have searched all the MySQL info I can find as
> well as the web at large, but nobody seems to have offered a real answer to
> the following problem, which many have had, though possibly only with Win32
> client machines accessing UNIX servers:
> 
> The problem arises when trying to populate a table on a server (in my case a
> Sun box) with data from a delimited text file from a client machine (in my
> case located in the root of the C: drive on a Win32 machine).   Using the
> command "LOAD DATA LOCAL INFILE "filename.txt" INTO TABLE tablename;"
> results in the error: "File 'filename.txt' not found (Errcode: 2)"
> 
> Thanks for listening

Solution to your problem is quite simple.

Simply set a full path of the file.

-- 
Regards,
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
       <___/   www.mysql.com

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to