Receiving file from remote source?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • nuhbye
    New Member
    • Jul 2010
    • 6

    Receiving file from remote source?

    The deign goes like this..

    I have a Mysql database on a linux system. It will receive a file from a remote location through GPRS and that file is to be processed and will then be loaded in the database.
    So, I want to know how to achieve this?
    How can we forward the file received to the database?
    How can Mysql can get to process this data?
    Do we have any support for doing this from Mysql?
    what to read in this context?
  • TheServant
    Recognized Expert Top Contributor
    • Feb 2008
    • 1168

    #2
    As far as I know, MySQL cannot parse a text file. You will need to run a script using another language (for example PHP) which will convert the text file into array(s) which it can then add to MySQL. What format is the file you're receiving? PHP has some good XML parsing ability, but otherwise you will need to read up on PHP opening and reading files.

    Comment

    Working...