search

mysql / mysql-shell-plugins

Plugins for the MySQL Shell
Other
70 stars 12 forks source link

How I can change local-infile? #40

Open PCoutoFR opened 9 months ago

PCoutoFR commented 9 months ago

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 commented 4 months ago

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