>>>>> "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
Halton> ERROR 13: Can't get stat of '/www/vhtdocs/pet.txt' (Errcode: 2)
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 ...'