FS#59655 - [mysql-workbench] load data local infile don't work anymore

Attached to Project: Community Packages
Opened by Laurent HOAREAU (laurent_waro) - Tuesday, 14 August 2018, 05:17 GMT
Last edited by Toolybird (Toolybird) - Wednesday, 17 May 2023, 21:27 GMT
Task Type Bug Report
Category Packages
Status Closed
Assigned To Christian Hesse (eworm)
Architecture All
Severity Low
Priority Normal
Reported Version
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 0
Private No

Details

Description:
When trying to import a file (csv) with mysql-workbench with the sql command " load data local infile '/home/user1/test.csv' mariadb return the error : "Error Code: 1148. The used command is not allowed with this MariaDB version"

This problem didn't appear with the anterious version of mysql-workbench (versions before mysql-workbench 8.0.12.x)

The global mariadb variable @@local_infile is set to 1
When trying the same sql command with another gui like dbeaver, execution is ok, so the error seems to be from mysql-workbench. Perhaps something to configure with it?

Additional info:
* package version(s) : 8.0.12.3
* config and/or log files etc.


Steps to reproduce:
use the sql command : load data local infile '/home/user1/test.csv'
This task depends upon

Closed by  Toolybird (Toolybird)
Wednesday, 17 May 2023, 21:27 GMT
Reason for closing:  No response
Comment by Toolybird (Toolybird) - Tuesday, 18 April 2023, 07:41 GMT
This is pretty old and stale. Still happening with latest pkgs?

Loading...