Exporting Structure and Data (Backup) - Mastering phpMyAdmin 3.4 for Effective MySQL Management - page 134

<column name="phone">+01 445 789-1234</column>
</table>
<table name="author">
<column name="id">2</column>
<column name="name">Maria Sunshine</column>
<column name="phone">333-3333</column>
</table>
</database>
</pma_xml_export>
Open document spreadsheet
This spreadsheet format is a subset of the open document ( http://en.wikipedia.
org/wiki/OpenDocument ), which was made popular with the OpenOffice.org
office suite. We need to choose only one table to be exported in order to have a
coherent spreadsheet. The following screenshot shows our author table, exported
into a file named author.ods , and subsequently looked at from OpenOffice:
Open document text
This is another subset of the open document standard, this time oriented towards
text processing. Our author table is now exported and viewed from OpenOffice.