I have a docker container running mysql (current) which I started with
docker run --name=mysql1 -d mysql/mysql-server
I need to import some data but the default image doesn't enable local-infile.
I don't want to break the currently running db or take it down for long.
What are my options? Is it possible to apply the --local-infile switch to an already-running container?
Thanks
local_infile is a global dynamic variable. To change at runtime execute the SQL:
SET GLOBAL local_infile=1
The client side that connects need local_infile set on the connection. If using the mysql client there is a --local-infile=1 option there, other wise look in the connection options if using a language/other script.
If you wanted to permanently enable this, the local-infile=1 option should be in the a my.cnf file in the server under a server group like [mysqld].