#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    1
    Rep Power
    0
    I am trying to execute the LOAD Infile command and I keep getting an error here is the exact code I am entering. I have already done a chmode on the txt file and it is located in the www directory on isp. I have also created the txt file in a tab delimited format with returns to end rows.
    mysql> LOAD DATA LOCAL INFILE 'home/vikingcomputrs/www/parts.txt'
    -> INTO TABLE parts
    -> FIELDS
    -> TERMINATED BY 't'
    -> LINES TERMINATED BY 'r';
    ERROR: File 'home/vikingcomputrs/www/parts.txt' not found (Errcode: 2)


    ------------------
    -rb
  2. #2
  3. No Profile Picture
    Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2000
    Location
    thane
    Posts
    50
    Rep Power
    0
    path is wrong

    try
    mysql->LOAD DATA LOCAL INFILE '/home/vikingcomputrs/www/parts.txt'
    -> INTO TABLE parts
    -> FIELDS
    -> TERMINATED BY 't'
    -> LINES TERMINATED BY 'r';

IMN logo majestic logo threadwatch logo seochat tools logo