Re: CSV to MySQL 8 issues

[Jim Sawyer]

I have the following line in my.ini

local_infile=true

I restarted the computer. I chheck with

mysql> show variables like 'local_infile'

it indicates that 'local_infile' is ON

I try to add a table to my database by using

load data locall infile 'C:/00_Output/Color.csv'
into table color
fields terminated by '|';

I still get the error message

ERROR 1148 (42000): The used command is not allowed with this MySQL version

What am I doing wrong?

Jim Sawyer