CODEWITHSUNDEEP
mysqlsqlxmldatabasedbimport
meOn
meOn

Reputation: 332

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

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

Upvotes: 0

Views: 765

Answers (1)

Shadow
Shadow

Reputation: 34231

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.

Upvotes: 0

Related Questions