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
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
|
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
Comment by Toolybird (Toolybird) -
Tuesday, 18 April 2023, 07:41 GMT
This is pretty old and stale. Still happening with latest pkgs?