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...

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:
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

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?

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.

"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.