Enable local-infile in Mysql on Docker

user_2839288 0
Viewed 1786

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

docker mysql
1 Answers

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].

user_101951530
Related