[ via Apple Web Developers list ] MySQL versions 3.23.48 and later can export tables in XML using the mysqldump command. Just add the --xml argument.
Markup in fields is escaped, to assure the output is well formed, so you’ll have to do some post processing if you’ve put XML or HTML fragments in your tables. If you’re using XSLT to process the output, you can use the disable-ouput-escaping attribute in xsl:value-of, as long as you understand that it’s a terminal step unless you’re working with extension functions that can manipulate nodesets.
Possibly Related posts (machine generated):