How I can change local-infile?

[PCoutoFR]

When I try to change advanced options to set local-infile =1 that not possible save configuration.

So have another way to set local-infile?

I also try change directly json settings like this

"mssql.connections": [
{
"server": "xxxx",
"database": "",
"authenticationType": "SqlLogin",
"user": "xxxxxx",
"password": "",
"emptyPasswordInput": xxx,
"savePassword": xxx,
"profileName": "xxxx",
"encrypt": "xxxx",
"trustServerCertificate": xxx,
"connectTimeout": 15,
"local-infile": 1,
"commandTimeout": 30,
"applicationName": "vscode-mssql"
}

[Bryon-Abbott]

Ran into the same issue ... tried to set the Option the same as Philipe via the
Edit Connection... --> Advanced --> Other Connection Options
like the MySQL Workbench but the option didn't seem to stick.

I ended up just running my script in terminal with mysql using the --local-infile option.

bryon@xxx:~$ mysql --local-infile -u bryon -p
...
mysql> source inputfile.sql;
...
mysql>

Happy to provide more details or help testing ...