Ssh mysql Load Data Infile


#1

I’m trying to insert data from a .txt file (in csv format) to one of my database tables using the LOAD DATA INFILE command as follows:

When I do so, it gives me an error:

I read in this thread that you can’t use an HTTP link for this command, but I can’t figure out what to do instead. Here’s a screenshot of where I am now:

Help would be greatly appreciated.


#2

MySQL can’t download the file for you. You’ll have to download the file first (using a tool like wget), and specify the filename you downloaded it as.

You’ll also need to change “LOAD DATA INFILE” to “LOAD DATA LOCAL INFILE”. The reasons for needing that are kind of technical, but have to do with your database server not being the same as your web server.


#3

That worked no problem! Thanks for the help.