Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Posts
    8

    Unhappy Unanswered: extract mysql data into xml format--URGENT

    all my database are inside mysql and i do not know on how to extract it and view it in the xml format. Im still beginner and really need someone to help and guide me on what to do. I would be appreciate if someone could help me on this and if possible, i really need to know the step by step on how to do it...
    thanx...

  2. #2
    Join Date
    Oct 2003
    Location
    Denver, Colorado
    Posts
    137

    Re: extract mysql data into xml format--URGENT

    It just takes one step. What you need to do is use the mysqldump program. Execute the program with the option -X or --xml. Here's an example:
    Code:
    mysqldump -X test > test.xml
    This dumps the test database into the test.xml file in XML format. You may need to provide a username and password, if your database requires it. If you need more information, check out the manual.
    http://www.mysql.com/doc/en/mysqldump.html

  3. #3
    Join Date
    Mar 2004
    Posts
    8

    mysql -> xml -> JSP

    that would dump all the database into the xml file.

    what i need to do is some sort of reporting for user log information for my system. i need to query all the log information from mysql into xml format and then display it using JSP and this should be done automatically whenever the user request for it. How do I do this - the simplest way?
    This is my first experience with xml and JSP and I just have no idea about it. Help.... anybody?

  4. #4
    Join Date
    Oct 2003
    Location
    Denver, Colorado
    Posts
    137

    Re: mysql -> xml -> JSP

    If you are going to do it directly from JSP, there is no MySQL-specific way of doing it. What you need to do is to look for a JSP tag library that will convert JDBC output to XML.

  5. #5
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482

    Re: mysql -> xml -> JSP

    Originally posted by t_ple81
    that would dump all the database into the xml file.

    what i need to do is some sort of reporting for user log information for my system. i need to query all the log information from mysql into xml format and then display it using JSP and this should be done automatically whenever the user request for it. How do I do this - the simplest way?
    This is my first experience with xml and JSP and I just have no idea about it. Help.... anybody?
    "that would dump all the database into the xml file" - That is not true because you can dump also specific table. Try mysqldump --help that tell you more.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •