Somebody asked in Freenode the other day how to get their data out of MySQL into a specific XML format.
Both mysqldump and the mysql client have –xml options. The output from the cli looks like this:
via A Little Noise » Blog Archive » mysql’s –xml and some XSLT.