Disregard my last post.. ----- Original Message ----- From: "Daniel Jarrett" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, April 22, 2002 11:44 PM Subject: Re: load data infile problems
> i figured it out.. it worked when i used local. > > although I keep getting a whole heap of warnings and skipping of records. > > i think i've got the layout of my txt file wrong.. > can anyone direct me to something that'll show me how to format my text file > for loading. > i find mysql manual a bit cryptic > > dan > > ----- Original Message ----- > From: "Melvyn Sopacua" <[EMAIL PROTECTED]> > To: "Daniel Jarrett" <[EMAIL PROTECTED]> > Cc: "MySQL General" <[EMAIL PROTECTED]> > Sent: Monday, April 22, 2002 9:48 PM > Subject: Re: load data infile problems > > > > The errorcodes in the brackets below indicate the error. > > > > You can find a human description, in /usr/include/errno.h > > > > For instance: > > grep 13 /usr/include/errno.h > > #define EACCES 13 /* Permission denied */ > > > > if there is no errno.h, use `locate' to locate it or try `man errno'. > > > > Daniel Jarrett said at 13:31 22-4-2002: > > > > > > >I'm having difficulties with loading values from a text file into my > > >databse. > > >I've tried the following and got these errors. last one is with full path > > >======================= > > >mysql> LOAD DATA INFILE "months.txt" INTO TABLE months; > > >ERROR 1105: File './date1/months.txt' not found (Errcode: 2) > > > > > >mysql> LOAD DATA INFILE "/months.txt" INTO TABLE months; > > >ERROR 13: Can't get stat of '/months.txt' (Errcode: 2) > > > > > >mysql> LOAD DATA INFILE "/home/danjar/months.txt" INTO TABLE months; > > >ERROR 13: Can't get stat of '/home/danjar/months.txt' (Errcode: 13) > > >======================== > > > > > >can anyone assit? > > > > > >thanks > > >dan > > > > > > > > >--------------------------------------------------------------------- > > >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 > > > > > > > > Best regards, > > > > Melvyn Sopacua > > WebMaster IDG.nl > > _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ > > If it applies, where it applies - this email is a personal > > contribution and does not reflect the views of my employer > > IDG.nl. > > \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\ > > > > > --------------------------------------------------------------------- > 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