mysqlimport and remote host

2001-04-11 Thread Lucy
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

Re: mysqlimport and remote host

2001-04-11 Thread Gerald Clark
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

Re: mysqlimport and remote host

2001-04-11 Thread Lucy
Hi Gerald Thanks a lot for the suggestion, but I'm not sure it will solve my prob, 'cos I dont want to copy a whole DB, and it's not on the same server anyway. I think it's my --local syntax in the mysqlimport (given in earlier message posted) that's dodgy. I've also tried an equals sign,