How to convert any MySQL table to XML

Submitted by mastereyes on Tue, 2009-09-08 20:31 in Magic Parser

Hi,

Is there any way to convert a MySQL table into XML file? I mean a standard way to convert any table to XML file by just giving the name of table?

Regards,

Matt

Hi Matt, I'm not aware of

Submitted by support on Wed, 2009-09-09 08:35

Hi Matt,

I'm not aware of any standard method at all i'm afraid. However, most of the MySQL administration tools have an export feature of which one option is an XML representation of a table rather than SQL. In phpMyAdmin, if you click the Export tab when browsing a table you'll see various options for exporting; including XML...

Cheers,
David.

Hi David, Yep, it is there.

Submitted by mastereyes on Wed, 2009-09-09 19:22

Hi David,

Yep, it is there. Thank you.

Regards,

Matt