On 12 Apr 2001, at 17:53, Lucy wrote:
> Hi
> I'm incredibly stuck. I've been through the lists over and over, and manual is
> silent on this detail, and have found no solution. The Unix remote host fails
> to find the text file to import from my pc, Win2000. The TABLE is created
> already. The text file is fine. I've done this via "load data infile" on
> localserver on my pc in MySQL no problem.
>
if you mysqlimport or mysql (client) on the win2k box then:
run program on win2k (ie mysqlimport or mysql client)
connect to the remote unix host, eg
c:\mysql\bin>mysql -u fred -p -h unix.somewhere.com DATABASE
enter password:
etc
mysql>load data local infile "d:/units.txt" replace into table units; etc
ie Run the client from where the data is but connect to the remote. I don't
think LOAD is supposed to work the way you are trying to use it.
The alternative is to ftp the data from win2k to UNIX then run mysqlimport
on the UNIX side.
David
> This is syntax I've tried:
> command prompt $>mysqlimport -u xxxx -p -h xxxxx --local DBNAME [problem
> part not finding try1.txt]
> "Errcode: 2 file try1.txt not found for table try1"
>
> Where do I place the text file on my pc for remote host to find it?
> How do I tell it where to go?
> The try1.txt is sitting on my pc, in d drive.
> Please can anyone help, and make my Easter? Cheers, Lucy
>
>
---------------------------------------------------------------------
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
