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