mysql ,"load data in file" , wrong file path

Question

I'm trying to upload the contents of a text file using this:

  myConn = DriverManager.getConnection("jdbc:mysql://localhost:3306/sys", "root", "*****8");

        Statement myStmt = myConn.createStatement();

        String sql="LOAD DATA INFILE"+ "'C:\\Users\\willf\\Documents\\comps sci\\NEA\\V1.4\\map files\\map.txt'"+"INTO TABLE sys.mazes";


        myStmt.executeUpdate(sql);

"java.sql.SQLException: File 'C:\ProgramData\MySQL\MySQL Server 8.0\Data\UserswillfDocumentscomps sciNEAV1.4map filesmap.txt' not found (OS errno 2 - No such file or directory)"

As you can see the filepath is completely different to what i'm giving it.

Remove the two quotes '. Use "C:\\Users\\willf\\Documents\\comps sci\\NEA\\V1.4\\map files\\map.txt" — Youcef LAIDANI
– Youcef LAIDANI, Commented Oct 29, 2019 at 15:12

Yserbius · Accepted Answer · 2019-10-29 15:10:57Z

1

MySQL is looking for a relative path using forward slashes. Try this instead: "'/C:/Users/willf/Documents/comps sci/NEA/V1.4/map files/map.txt'"

answered Oct 29, 2019 at 15:10

Yserbius

1,40413 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Fred Over a year ago

thanks ,file path seems to be right now ,but says can't find file with error "OS errno 13 - Permission denied"

Mark Rotteveel Over a year ago

@Fred As far as I know, LOAD DATE INFILE is executed by the MySQL server process, which is run by a user that doesn't have access to your user folder.

Fred Over a year ago

@MarkRotteveel I tried using LOCAL aswell but its not supported in my sql version apparently.

Fred Over a year ago

whats the recommened way of uploading the contents of a txt file ?

Yserbius Over a year ago

@Fred Depends on the type of file. If it's a SQL file, the recommended way is just to read it in via the command line. For a CSV, there are multiple approaches, none bad. Best way would probably be to just write a Java program that parses it and updates the table row by row.

Collectives™ on Stack Overflow

mysql ,"load data in file" , wrong file path

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related