sql - MySQL LOAD DATA Error (Errcode: 2 - "No such file or directory") -

i trying load data table of mysql database, , getting error.

load data local infile 'c:\users\myself\desktop\blah blah\load data\week.txt'  table week; 

reference: this

the path hundred percent correct, copied pressing shift , clicking "copy path as" , checked many times. so tips on appreciated. . my research: seeing this answer, tried changing c:\users c:\\users. did not work me.

secondly, is there way use kind of relative path (rather absolute path) here?

i don't know version of mysql using quick google search found possible answers both questions. below excerpts mysql 5.1 reference manual:

the file name must given literal string. on windows, specify backslashes in path names forward slashes or doubled backslashes

the local keyword affects file expected found:

if local specified, file read client program on client host , sent server. file can given full path name specify exact location. if given relative path name, name interpreted relative directory in client program started.

regards.