Check the structure of txt file. Does it created with SELECT ... INTO
OUTFILE? Check command syntax.
----- Original Message -----
From: Joel Holtzman <[EMAIL PROTECTED]>
To: Nielsen <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, February 12, 2001 8:51 AM
Subject: Re: CREATE TABLE / Telnet (Linux / Unix server)
> I've had questions about this too. What happens if I have a primary key,
and
> the text file has the columns that are in the existing table, with
records.
> And I want to insert them. How do I get rid of that duplicate error? I
read
> the manual, about 'ignore' but I can't get it to work.
>
> Any ideas?
>
> In other words, if I have a db with one table "Test" and columns:
> A B
>
> And my file.txt has the columns and records, so it's structured like this:
> A B
> 1 2
> 3 4
>
> So when I 'load data infile file.txt' the db with 'test' table and 0
> records, becomes table with records added.
>
> How do I avoid errors. The manual is no help, I tried it. Any ideas?
SHould
> I ignore the Primary key field in the text file, and use the rest of it to
> avoid that duplicate error? The text file is separated by tabs.
>
> Thanks
>
> Joel
>
>
> ----- Original Message -----
> From: Nielsen <[EMAIL PROTECTED]>
> To: C.o.m.b.u.s.t. <[EMAIL PROTECTED]>;
> <[EMAIL PROTECTED]>
> Sent: Sunday, February 11, 2001 9:24 PM
> Subject: RE: CREATE TABLE / Telnet (Linux / Unix server)
>
>
> > > ...and this will load the table into your database. Now, in the book
> > > it doesn't specify whether or not you have to be on the computer with
> > > the server, or if you can send the .sql file command from your
> > > computer to the remote server, sort of like a file transfer protocol
> > > as well. Basically, my question is, do I have to either FTP my files
> > > to the server, and then execute the command, or can I do it remotely
> > > without FTP? Or is it possible AT ALL to execute the command from a
> > > remote computer? In case it helps, I am on a Windows 98 system
> > > connected through SSH to an Linux system running Apache. Please
> > > help, I'm stuck and I won't give up until I'm un-stuck! Thanks in
> > > advance to all that reply.
> >
> > The file must be on the remote machine (as has been answered), but yes,
if
> you
> > are connected to the shell (via telnet/ssh/ssh2/etc), you can execute
the
> > command. And, no, the extension may be anything (all you're doing is
> > redirecting the contents of the file (via '<') into the 'mysql
<database>'
> > command.
> >
> > HTH,
> >
> > Jon A. Nielsen.
> >
> >
> > ---------------------------------------------------------------------
> > 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
>
>
---------------------------------------------------------------------
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
