Re: LOAD DATA INFILE again ...
Posted by: Peter Brawley
Date: June 07, 2019 07:32PM

> Sounds like a deliberate error to me.

By a deliberate error I mean a on-purpose syntax error, eg misspell a variable name. MySQL will fail to load. That will prove MySQL is using that file.

> Can I pay you for your support?

Possible but it gets both expensive and frustrating quickly ... usually the moves I'm suggesting lead to a solution, and others learn from it.

Your problem has several relevant components...

1 whether mysqld.exe is using the my.ini file you think it is

2 secure_file_priv setting

3 local_infile setting

4 connector/j interface (btw 5.5 isn't on the list of supported mysql versions for connector/j 8.0)

You need to solve one of these at a time. For #1, please ...

- try the above

- post my.ini contents

Options: ReplyQuote




Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.