If you can ssh to the host you should be able to
use scp to copy the file over.
Lucy wrote:
>
> Hi
> I'd successfully loaded a text file to a previously created table on my
> localhost/server. It all works fine.
> I'm having trouble doing the same to a remote host. I've checked the manual
> for the syntax for --local, which is probably the problem. I'm not allowed
> to FTP the file to the remote's database server.
>
> 1. I have to initially go through SSH to access the remote host server.
> Fine, I get through to the shell prompt.
> 2. I use username, password, and DB Name to access the remote server, which
> I handle through the mysqlimport options OK.
> 3. I understand the basic mysql syntax except for interpreting the --local
> option :
> shell>mysqlimport [options] database textfile1
>
> How do I specify the --local option to tell the remote host where to find
> the location of the textfile on my pc?
> I've also placed a copy of textfile on the pc's d drive (outside subdirecs),
> to reduce complications of forward/back slashes system differences. Same
> error code Errcode2, can't find file for table. Do I need to specify
> something else with --local, such as the Port Number? I tried specifying
> via the SSH port, but no go.
>
> Some variations I've tried unsuccessfully include:
> shell> mysqlimport ...etc... databaseName --local textfile1
> shell> mysqlimport ...etc... databaseName --local "d:textfile1"
> shell> mysqlimport ...etc... databaseName --local "d:\\subdir\\textfile1"
> shell> mysqlimport ...etc... databaseName --local "d:subdir.textfile1"
> shell> mysqlimport ...etc... databaseName --local "d:\subdir\textfile1"
> shell> mysqlimport ...etc... databaseName --local "d:/subdir/textfile1"
> shell> mysqlimport ...etc... databaseName --local -P xx
> "d:\\subdir\\textfile1"
>
> Can anyone help me with syntax to specify the --local option to tell the
> remote host where to find the location of the textfile on my pc? 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
---------------------------------------------------------------------
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
