I'm pretty new to SQL, MySQL and Docker. I'm running a Docker MySQL container (I believe).
In MySQL, the command
select * from [tablename] into outfile [csv-filename];
fails with the message
The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
What I've tried:
outputs a value of NULL.
Then, I changed/added the line
into both of the following files within the container:
Still, "select @@GLOBAL.secure_file_priv;" in MySQL returns NULL and "(...) into outfile (...);" fails as described above.
Any clues are much appreciated!