Relative Content

Tag Archive for load-data-infile

Using a Macbook Pro, how to modify my.ini to allow load data infile for CSV files

I’m using a mac and MySql via Sequel Ace. I have reports that require daily imports of CVS files into my database. I can import them manually (File | Import) however, all attempts to automate the process with a call to LOAD DATA INFILE fails with an error message of:
The MySQL server is running with the –secure-file-priv option so it cannot execute this statement