Question: I get the error message. I am using phpAdmin

2000 - Can't find file 'c:/tmp/userlist.csv'.
=============================================

LOAD DATA LOCAL INFILE 'c:/tmp/userlist.csv'
INTO TABLE users2
FIELDS TERMINATED BY ';'

LINES TERMINATED BY '\n';

I have googled and that error seems to be a lot of other things too.

It does exist as i have just pasted into windows and it opens the file.

Answer: 
With `LOAD DATA LOCAL` the file is read locally and it needs to be accessible by the client. You mentioned you are using phpMyAdmin (a MySQL client), so the file needs to be accessible from wherever phpMyAdmin is running from.

If phpMyAdmin isn't installed on your computer, then you need to upload the file to the server where it's located and change the file path accordingly.

---

Another solution would be to install a MySQL client on your computer to run the query, so it can read the file locally. I recommend [MySQL Workbench](http://www.mysql.com/products/workbench/).
The only thing I had to do in the end was press IMPORT inside phpMyadmin. It would have been nicer if somebody had told me that instead of mucking around for two days trying to import a csv via sqls.