Home > database >  The latest version of mysql community edition load data local infile error 2068
The latest version of mysql community edition load data local infile error 2068

Time:09-16

Learning SQL recently, see screenshot
Order to perform the load data is always an error 2068 questions, online search solution, found that the problem without any web page said, who is a great god to see ah

CodePudding user response:

Try on the command line, may tool does not support the load data of writing

CodePudding user response:

reference 1st floor sxq129601 response:
try on the command line, may tool does not support the load data written
doesn't work

CodePudding user response:

No one know, tried all kinds of methods: started the local data loading, also set up the client load directory, but are still the wrong, I am using the command line

CodePudding user response:

reference weixin_44431556 reply: 3/f
no one know, tried all kinds of methods: started the local data loading, also set up the client load directory, but are still the wrong, I am using the command line



SHOW VARIABLES LIKE '% local %' need to be on or 1 to use the load data

CodePudding user response:

Tried, you said the whole set, is to start a local data loading, useless, you can over there? You can cut a figure? My screenshot is the following:

CodePudding user response:

reference 5 floor weixin_44431556 reply:
tried, you said the whole set, is to start a local data loading, useless, you can over there? You can cut a figure? My screenshot is the following:
are you done? If not for the way you said I you try for a while

CodePudding user response:

Not yet, you tell me about your method, thank you,

CodePudding user response:

Recently encountered such a problem, my solution see https://blog.csdn.net/weixin_39080421/article/details/108492155

CodePudding user response:

Another way: the command line, in the same directory of this file, execute the mysql - uroot this, can be directly mysql> The source of xx. TXT;
  • Related