How to load remote location xml file data to mysql/(any other) database

Question

I have found the solution to load xml file data to mysql db table Here

My question is how I can load remote location xml file and dump it to mysql database table.

If you have any idea or have done something like this please help to find the solution.

Thank you

Answer 1

LOAD XML statement does not support retrieving files from a remote location. The file has to be either on the server, or on the client (LOCAL - if enabled in configuration). You need to write a script that saves the file either to the server or to the client from the remote location.

If you manage to map a remote shared directory to the local fileszstem, then you can import data that way.