ERROR 1148

[harshsharma09]

Need you help!

When i executed this query i got; ERROR 1148: The used command is not allowed with this MySQL version. I tried changing Infile settings on client and server both. Still the same error. Now, i have to manually convert excel into csv and then upload for each table. Its is taking almost 20 hours for each import.

I am using MySQL 8

[pgwilliams]

Hi @harshsharma09 yes we'd seen that specific problem before hence the notes at the bottom of the readme file. However we've not yet run against MySQL8.

This stack article: https://stackoverflow.com/questions/10762239/mysql-enable-load-data-local-infile ...suggests the following:

I solved this problem on MySQL 8.0.11 with the mysql terminal command: SET GLOBAL local_infile = true; I mean I logged in first with the usual: mysql -u user -p* After that you can see the status with the command: SHOW GLOBAL VARIABLES LIKE 'local_infile'; It should be ON.

Do please let us know how you get on and we'll perhaps update that Readme.

[harshsharma09]

Hi @pgwilliams Thanks for your help. Happy New Year 2019. I tried your solution. It is shows 'ON" when execute command SHOW GLOBAL VARIABLES LIKE 'local_infile'; However, when i am running the query in MySQL workbench its gives the same error 1148. Really no idea what to do....i have multiple tables with almost 4 million records each. Takes days to do it manually.

[pgwilliams]

Happy New Year to you too @harshsharma09

I'll try to reproduce this issue and work through it from there. What operating system are you using? Thanks & Best Wishes, Peter

[harshsharma09]

HI @pgwilliams i am working on 64 bit Windows 7 Enterprise. Thanks

[kaicode]

Closing this issue as it's very old. Please reopen if it's still a problem.

[hsharma09]

Thank you, Kai, for the notification.