I mean, did you select into outfile from mysql or try to import file with
some other format.
You are trying to import file with some structure, where fields and lines
are separated with some characters.
You have to read manual on LOAD DATA INFILE.
----- Original Message -----
From: Joel Holtzman <[EMAIL PROTECTED]>
To: Rus <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, February 13, 2001 1:15 AM
Subject: Re: CREATE TABLE / Telnet (Linux / Unix server)
> I turned my access db into excel, and into .csv
>
> So that's the structure of my text file. When I use "Load data infile..."
> I get the 10 warnings. 10 for the 2 columns, and 8 records. Does it have
to
> be a special format? I have the file.txt on the server. I can point to it.
I
> just can't get it to insert this file's records. Are you saying when
columns
> exist in a db, you must use Select into?
>
> And does the file need to have columns/records sepearated a certain way?
> Mine uses commas. (.csv file)
>
> Thanks
>
> Joel
>
>
> ----- Original Message -----
> From: Rus <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, February 12, 2001 1:21 AM
> Subject: Re: CREATE TABLE / Telnet (Linux / Unix server)
>
>
> >
> > 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
> >
> >
>
>
---------------------------------------------------------------------
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
