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
Reading about this error has lead to a fix to the “my.ini” file. I can not find that file!
I’ve also executed to queries to show system and global variable or “OFF” and the secure_file_priv variable is NULL.
I’m out of options but would like to automate my routines for importing data.
- Finding the My.ini file
- Viewed the system variables
- Viewed the secured_file_priv variable
- Searched my Mac for the My.ini file
- Googled searched for options to resole
Jean Antoine is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.