mysqlimport and remote host
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 : shellmysqlimport [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
Re: mysqlimport and remote host
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 : shellmysqlimport [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
Re: mysqlimport and remote host
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, doubling the "\" character for Windows 2000 and also Unix style `/' character: shellmysqlimport ..etc.. DBName --local="d:\\textfile1" shellmysqlimport ..etc.. DBName --local='d:/textfile1' shellmysqlimport ..etc.. DBName -L textfile1 shellmysqlimport ..etc.. DBName -L "d:\\textfile1" shellmysqlimport ..etc.. DBName -L 'd:/textfile1' shellmysqlimport ..etc.. DBName -L="d:\\textfile1" The error code still states can't find file for the table (already created). (I'm trying to import textfile from pc Win2000 to remote host, via SSH, and using mysqlimport options for username, host, password, not allowed to FTP to remote DB server). 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