Using MySQL Load Data Local Infile — SQL code examples


Security Issues with MySQL have resulted in changes to command procedures. An error 1148 is kicked up when load data local infile ‘…’ is used. To avoid this you must start mysql from the command line: $mysql –local-infile=1 -uyourname -ppassword mysql>source projects/utility/mysql2016/create_load_ohlc.sql Once the parameter: –local-infile=1 is set, then the load data local command […]

via Using MySQL Load Data Local Infile — SQL code examples

Advertisements