![]() ![]() The option local_infile is Boolean, not numeric.Īnd restarting mysql does not work either, you will have to start up mysql with something like this: echo "SET GLOBAL local_infile = 'ON' " > /var/lib/mysql/init_file.sqlĬhown mysql:mysql /var/lib/mysql/init_file.sql I said use SET GLOBAL local_infile = 'ON' Please note I did not say SET GLOBAL local_infile = 1 If it still says 'OFF', then look deep within the compiler settings to enable it. Mysql> SHOW GLOBAL VARIABLES LIKE 'local_infile' It should echo the following: mysql> SHOW GLOBAL VARIABLES LIKE 'local_infile' SHOW GLOBAL VARIABLES LIKE 'local_infile' If the MySQL Debian-7 minimal cannot use local_infile, look around all the make files used for compiling to see if it is disabled by default or if local_infile is enabled for the Debian-7.īefore taking that kind of time, please run the following: SHOW GLOBAL VARIABLES LIKE 'local_infile'
0 Comments
Leave a Reply. |