RE: [MLUG] MySQL Tutorial on MySQL 3rd Edition by Paul DuBois

["Pottinger, Hardy J." <EMAIL:PROTECTED>]

Check both of these:

http://dev.mysql.com/doc/mysql/en/mysqlimport.html

http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/doc/en/LOAD_DATA_LOCAL.
html

My hunch is you need to add --local or --local-infile (depending on what
version of client you're using) when you launch the mysql client.

--Hardy 

> -----Original Message-----
> From: EMAIL:PROTECTED 
> [mailto:EMAIL:PROTECTED] On Behalf Of Pepper, Mike
> Sent: Tuesday, June 07, 2005 11:34 AM
> To: MLUG Members
> Subject: RE: [MLUG] MySQL Tutorial on MySQL 3rd Edition by Paul DuBois
> 
> Even when I fully qualify the name I get the same error...
> 
> ----------------------------<start
> file>-------------------------------------
>  mysql> LOAD DATA LOCAL INFILE 'member.txt' INTO TABLE 
> member; ERROR 2 (HY000): File 'member.txt' not found (Errcode: 2)
> mysql> LOAD DATA LOCAL INFILE '/home/mike/sampdb/member.txt' 
> INTO TABLE
> member;
> ERROR 2 (HY000): File '\home\mike\sampdb\member.txt' not 
> found (Errcode:
> 2)
> mysql>
> -----------------------------(end
> file>--------------------------------------
> 
> 
> -----Original Message-----
> From: EMAIL:PROTECTED
> [mailto:EMAIL:PROTECTED] On Behalf Of 
> Pottinger, Hardy J.
> Sent: Tuesday, June 07, 2005 11:25 AM
> To: MLUG Members
> Subject: RE: [MLUG] MySQL Tutorial on MySQL 3rd Edition by Paul DuBois
> 
> You need to fully qualify the /path/to/the/file, IIRC.
> 
> --Hardy
> 
> > -----Original Message-----
> > From: EMAIL:PROTECTED 
> > [mailto:EMAIL:PROTECTED] On Behalf Of Pepper, Mike
> > Sent: Tuesday, June 07, 2005 11:07 AM
> > To: MLUG Members
> > Subject: [MLUG] MySQL Tutorial on MySQL 3rd Edition by Paul DuBois
> > 
> > I am working my way through the book MySQL by Paul DuBois 
> 3rd edition 
> > that was recommended to me by members on this list.
> > My question is that the book has some sample files that I 
> was able to 
> > go out and download.
> > I am to a point in the book where it is talking about the import 
> > function. He lays my problem.
> > I installed MySQL on my SuSE 9.3 machine, both the client 
> and server 
> > files.
> > I installed the sample files to my home directory. No where in the 
> > book or the read me files tells me to install the files in 
> a different
> 
> > location.
> > When I attempt to run the statement: LOAD DATA LOCAL INFILE 
> > 'member.txt'
> > INTO TABLE member;
> > I get an error message stating that it could not find the file. 
> > <ERROR 2 (HY000): File 'member.txt' not found (Errcode: 2)> My 
> > question is that is there anyway that I can state the path, 
> or where 
> > can I copy the data to where it can find it?
> > 
> > Thanks in advance.
> > 
> > Mike
> > 
> > _______________________________________________
> > members mailing list
> > EMAIL:PROTECTED
> > http://mlug.missouri.edu/mailman/listinfo/members
> > 
> 
> _______________________________________________
> members mailing list
> EMAIL:PROTECTED
> http://mlug.missouri.edu/mailman/listinfo/members
> 
> _______________________________________________
> members mailing list
> EMAIL:PROTECTED
> http://mlug.missouri.edu/mailman/listinfo/members
> 

_______________________________________________
members mailing list
EMAIL:PROTECTED
http://mlug.missouri.edu/mailman/listinfo/members