On Wed, 2 Jan 2008 17:35:41 -0500, "don" <don@panix.com>
wrote:

>I am taking the MySQL tutor lesson
>http://dev.mysql.com/doc/refman/4.1/...ng-tables.html
>
>but when I use the command LOAD DATA LOCAL INFILE 'my path/pet.txt' INTO
>TABLE pet;
>
>I get ERROR 2 fiLE '..... ' NOT FOUND
>
>I'm sure there is a simple solution to this, but so far Tech Support at
>Network Solutions has not been able to solve it.

Because you asked support from Network Solutions I assume
your MySQL service is on their server and the file is on
your PC at home.
The MySQL server has to connect to you to get the file.
This in itself can be dangerous.
Therefore it has to be activated in the mysql.exe
commandline, something like:
mysql -h host -u user -ppassword --local-infile=1 database

Also, it can be blocked on the server.

http://dev.mysql.com/doc/refman/5.0/en/load-data.html
http://dev.mysql.com/doc/refman/5.0/...ata-local.html

HTH
--
( Kees
)
c[_] Once a newspaper touches a story, the facts are lost
forever, even to the protagonists. (Norman Mailer) (#344)