how to specify a fully qualified path in a LOAD DATA command in iMac OS X

[John Connell]

I am trying to issue the command
LOAD DATA LOCAL INFILE '....path on a Mac OS X...' INTO TABLE tablename; .

I've tried various formats for the path, eg,
'/Users/MyHome/DeskTop/ filename ' with no success.

I keep getting "not found (OS errno 2 - No such file or directory)" as the response.

I need to know how to correctly qualify the file path in OS X.

Thanks,