Re: Error code 1290 - secure-file-priv not working

[Barry Galbraith]

Quote

The output of SHOW VARIABLES LIKE 'secure_file_priv'; is "C:\mySQL"

Quote

LOAD DATA INFILE 'C:\mySQL\Uploads\Import Addresses to mySQL.csv'

What if you put your file in C:\MySQL rather than C:\MySQL\Uploads ?

or set your secure_file_priv to C:\MySQL\Uploads

A word to the wise. Sometimes MySQL treats \ character as escape rather than separator. That means you might need C:\\MySQL\\Uploads
MySQL will happily use / as separator
That means you can use C:/MySQL/Uploads

Good luck,
Barry.