I think that this may have something to do with your use of the 'LOCAL' keyword. The manual page stipulates that the LOCAL keyword will load a file from the standpoint of the client-side... MySQL sends a request to the client-side program and requests it to upload that file. So in order to use LOCAL I think that you would need to use an absolute path. If the LOCAL keyword is not specified then MySQL will look for the file from the server-side standpoint, whereas you may access the file from the database directory, a relative path from the root www directory (methinks anyhow, the manual says the server data directory), or an absolute path.
That's my suspicion. The manual page also mentions security settings that need to be in place before accessing the file server-side will be possible.
If you want to stay with the LOCAL keyword, plug in an absolute path. Which would be something like this.
C:\\Inetpub\\wwwroot\\project\\pet.txt
hth
: )
Rich
:::::::::::::::::::::::::::::::::
Smiling Souls
http://www.smilingsouls.net
:::::::::::::::::::::::::::::::::