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

Reply via email to