List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:April 1 1999 10:40pm
Subject:RE: Basic Data Import Query
View as plain text  
>>>>> "Halton" == Halton Internet <info@stripped> writes:

Halton> Thanks Drew
Halton> Yes it is unix and I get the same with

mysql> load data infile '/www/vhtdocs/pet.txt'
-> into table kennels
-> fields terminated by ','
-> enclosed by '"'
-> lines terminated by '/r'
-> (name, address1, address2, town, county ,postcode ,bustype ,telephone
-> ,fax);
Halton> ERROR 13: Can't get stat of '/www/vhtdocs/pet.txt' (Errcode: 2)

Hi!

The errcode 2 means:
shell> perror 2
No such file or directory

Are you sure you have the above file one the same machine where the
mysqld server is running ?

If not, try the command 'LOAD DATA LOCAL INFILE ...'

Regards,
Monty
Thread
Basic Data Import QueryJon Halton1 Apr
  • Re: Basic Data Import QueryDrew M Hahn1 Apr
    • RE: Basic Data Import QueryHalton Internet1 Apr
      • Copying live filesBrandon Pulsipher1 Apr
        • Copying live filesMichael Widenius2 Apr
      • RE: Basic Data Import QueryPaul DuBois2 Apr
      • RE: Basic Data Import QueryMichael Widenius2 Apr
Re: Copying live filesjkraai2 Apr
RE: Copying live filesBrandon Pulsipher2 Apr