How to import data from local text file to mysql database

Question

How can I load data to a MySQL server from a text file that is on my computer? I follow the procedure I found in this former question, but I think it is required for you to have the data file on your server. If I try, I receive an #1045 - Access denied for user 'learnsql'@'localhost' (using password: NO). I do not know if the two things are related.

I ran:

 LOAD DATA INFILE  'C:\Users\Me\Google Drive\dataset\userid-timestamp-artid-artname-traid-traname.tsv' INTO TABLE dataset

@Anony-Mousse, opening your car and sitting in it is not driving either, but it is a quite important step in the process. — Edgar Derby, Aug 18 '13 at 08:55
then you should have tagged the question "file", "character set", "windows", because all of these are more relevant to your question than data mining... — Has QUIT--Anony-Mousse, Aug 18 '13 at 11:51

score 1 · Answer 1 · answered Aug 17 '13 at 11:33

1

The "learnsql" user must have FILE privileges.

grant file on *.* to user@localhost identified by 'password';

And MySQL must have operating system access to files, of course.

answered Aug 17 '13 at 11:33

vidario

479
2
5

Hi, @vidario, thank you for the advice. My knowledge of MySQL is lacking, which part of your query should I edit in order to use it? Because if I try to run it as it is I receive the same error: "#1045 - Access denied for user 'learnsql'@'localhost' (using password: NO)". Also, once I have the file privileges, can I load data from my machine or do have I to upload the file on the server trough FTP? – Edgar Derby Aug 17 '13 at 11:46

How to import data from local text file to mysql database

1 Answers1