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.


Comments

Post a Comment

Popular posts from this blog

java - Intellij Synchronizing output directories .. -

-
i trying build project, run in debug mode , keep getting "synchronizing output directories" in intellij. takes around 5-10 minutes actual build. project empty , stored on local drive. tried invalidate catche has not worked. out of ideas .. had similar issues? most likely, of data on network drive or in profile being synchronized network drive. if on windows, try moving .ideaxxx/system directory , work directory somewhere else on c: drive.
Read more

git - Initial Commit: "fatal: could not create leading directories of ..." -

-
i trying make initial commit git repository on github unity project. followed along this guide am. note: reason or another, couldn't set unity's asset serialization mode force text, settled on mixed (which believe should work). when call git clone --bare . , error. note not creator of repository , contributor (though making initial commit). here's in terminal (i'm using git bash): welcome git (version 1.8.4-preview20130916) run 'git git' display index. run 'git <command>' display specific commands. cheddar@cheddar-pc ~ $ cd documents/ics168swarch/ cheddar@cheddar-pc ~/documents/ics168swarch $ git init initialized empty git repository in c:/users/cheddar/documents/ics168swarch/.git / cheddar@cheddar-pc ~/documents/ics168swarch (master) $ git add . warning: lf replaced crlf in assets/prefabs.meta. file have original line endings in working directory. warning: lf replaced crlf in assets/prefabs/pellet.prefab.meta. file have original
Read more