markowe
10-10-2009, 01:49 AM
I discovered that you have to use the LOCAL setting with this command for security reasons, but what I can't figure out is how to specify the path to my text file, or rather where to place the file. In the context of Bluehost, if I do "LOAD DATA LOCAL INFILE 'myfile.txt' ... ", where is it actually looking? If I want to locate the file in a server directory, how do I do that? I tried 'home/USERNAME/public_html/mydirectory' but still couldn't locate it.