I am using mysql 8.0 at server machine and mysql 5.5 at client machine, but when i am trying load local infile query from client machine the query is getting executed successfully but data is not getting uploaded into the server database
but when i am trying to execute the same query on client machine using sqlyog and connecting to Server machine mysql the query is getting executed successful and data is getting uploaded on the server side.
My client machine application uses mysql ODBC driver to communicate with Server machine mysql.
Any suggestion why i am getting this kind of issue.