I'd like to load a text file that is located in a NetBeans project folder.
What is the default relative path (if one exists in
LOAD DATA LOCAL INFILE
From the MySQL documentation for
LOAD DATA LOCAL INFILE:
If LOCAL is specified, the file is read by the client program on the client host and sent to the server. The file can be given as a full path name to specify its exact location. If given as a relative path name, the name is interpreted relative to the directory in which the client program was started.
You should try using the location of the client program as being the start of the relative path. The directory of the compiled code does not seem to have anything to do with this.