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