exporting from sql - as xml

[Toadums]

Hey...cant quite figure this out..usually when i perform something on my phpmyadmin server - it will display what the sql code is

but when I try to export it, it just gives me the code (in xml), not sql:

<?xml version="1.0" encoding="utf-8" ?>
<!--
-
- phpMyAdmin XML Dump
- version 2.11.9.4
- http://www.phpmyadmin.net
-
- Host: mysql.pdem.info
- Generation Time: Jul 20, 2009 at 02:42 PM
- Server version: 5.0.67
- PHP Version: 5.2.9
-->

<!--
- Database: 'pdem_timesheets'
-->
<pdem_timesheets>
  <!-- Table tblTimesheet -->
    <tblTimesheet>
        <TimesheetID>635</TimesheetID>
        <Name>Paul</Name>
        <Date>2009-06-15</Date>
        <Hours>5</Hours>
        <Phase>NR - Non-Recoverable</Phase>
        <Approved>0</Approved>
        <ProjectID>000-00000</ProjectID>
        <Description>User page/standards</Description>
        <Type>HRC</Type>
    </tblTimesheet>
    <tblTimesheet>

which is the xml code (what I want) but I would like to know the command in sql to export a database as an xml file.

[CoderDan]

take a look at the mysql docs - looks like it's a flag you start mysql with...

[Toadums]

can i call this from php?

mysql_query(mysqldump [options] db_name [tables])?

[Randy_Jackson]

I'd take a look at the Program Execution Functions. Likely one of those will do what you need.

If you can't run mysqldump directly, I know that you can call it from a batch file if needed.