Hi Joe (and Nancy ;-) ),
On Fri, Feb 23, 2001 at 05:23:10PM -0500, Joe and Nancy M wrote:
> I have my database created on my ISP's server. I can telnet to it and log in. I
>have created my table. I inserted 4 test records. I have written my .php3 pages and
>pull the data and get the results I want. Now.... I need to populate the table with
>hundreds of records exported out of Peachtree. I can get a tab delimited file, no
>problem. I will clear this table weekly and re-import the entire record set, so I
>obviously do not want to insert record by record.
>
> I telnet to my ISP, login, then login to the mysql server with mysql
>-hlocalhost.isp.com. -p databasename
> Then from mysql>, I type: mysqlimport -d --local cur myfile.txt
>
mysqlimport is a command you would start from the telnet prompt,
not from the mysql prompt.
> where -d means delete the existing records, --local means get the file from the
>client, cur is my table and myfile.txt is the file on my hard drive. Again, I get
>parse errors.
>
> Any thoughts on the command string?
> Also, how do I specify the folder on the client? (c:\a\myfile.txt)
>
I never used it, but I guess it will use the current directory
or you can just specify a filename including its path. E.g.
/home/joe/myfile.txt or even ~/myfile.txt.
Regards,
Fred.
--
Fred van Engen XO Communications B.V.
email: [EMAIL PROTECTED] Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424 The Netherlands
---------------------------------------------------------------------
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