Exporting Structure and Data (Backup) - Mastering phpMyAdmin 3.1 for Effective MySQL Management - page 128

XML
This format is very popular these days for data exchange. Choosing XML in the
Export interface yields no choice for options. What follows is the output for the
author table.
<?xml version="1.0" encoding="utf-8" ?>
<!--
-
- phpMyAdmin XML Dump
- version 3.1.1
- http://www.phpmyadmin.net
-
- Host: localhost
- Generation Time: Dec 21, 2007 at 01:13 PM
- Server version: 5.0.67
- PHP Version: 5.2.6
-->
<!--
- Database: 'marc_book'
-->
<marc_book>
<!-- Table author -->
<author>
<id>1</id>
<name>John Smith</name>
<phone>+01 445-789-1234</phone>
</author>
<author>
<id>2</id>
<name>Maria Sunshine</name>
<phone>333-3333</phone>
</author>
</marc_book>
Native MS Excel (pre-Excel 2000)
phpMyAdmin offers an experimental module to export directly into a .xls
format—the native spreadsheet format understood by MS Excel and OpenOffice
Calc. When this support is activated (more on this in a moment), we see a new export
choice, Native MS Excel , and the same options as those for Microsoft Excel 2000.