Sql to XML migration

Discussion in 'MySQL' started by logiczone, Sep 29, 2008.

  1. #1
    Hi there. Do anyone of you here have done this already? I have bunch of sql in my hard drive but I can't find any on the web that converts sql to XML. Can you please guide me with this? Thank you very much! Replies are much highly appreciated. Thanks!
     
    logiczone, Sep 29, 2008 IP
  2. chisara

    chisara Peon

    Messages:
    141
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    0
    #2
    My personal strategy would be to first load the SQL into the Database server that exported it.
    Then find an backup system for your unnamed database server that outputs XML files or write a small script that rolls through the database and outputs the data in your own XML schema.
     
    chisara, Sep 30, 2008 IP
  3. WebSolutions86

    WebSolutions86 Peon

    Messages:
    434
    Likes Received:
    25
    Best Answers:
    0
    Trophy Points:
    0
    #3
    go to phpmyadmin
    import the sql and export as xml :D

    without phpmyadmin, i don't think theres a way out
     
    WebSolutions86, Sep 30, 2008 IP
  4. chisara

    chisara Peon

    Messages:
    141
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Yes if the assumption is made that he is using Mysql as his database server then he can just use mysqldump with --xml switches from the commandline, no phpmyadmin is needed.
     
    chisara, Sep 30, 2008 IP
  5. chathura87

    chathura87 Peon

    Messages:
    60
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    How we can represent mysql data using xml
    Please put a simple example!!
    Thank your
     
    chathura87, Oct 1, 2008 IP