Exporting Structure and Data - Mastering phpMyAdmin 2.8 for Effective MySQL Management - page 118

1. Ensure that the PHP server has PEAR support. (The pear command will fail

if we do not have PEAR support.) PEAR itself is documented at
http://pear.php.net .

2. If we are running PHP in safe mode, we have to ensure that we are allowed

to include the PEAR modules. Assuming the modules are located under;
/usr/local/lib/php , we should have the line safe_mode_include_dir =
/usr/local/lib/php in php.ini .

3. We then install the module with: pear -d preferred_state=beta install

-a Spreadsheet_Excel_Writer (because the module is currently in beta
state). This command fetches the necessary modules over the Internet and
installs them into our PEAR infrastructure.

4. We need a temporary directory - under the main phpMyAdmin

directory - for the .xls generation. It can be created on a Linux system with:
mkdir tmp ; chmod o+rwx tmp .

5. We set the $cfg['TempDir'] parameter in config.inc.php to './tmp' .

We should now be able to see the new Native MS Excel data export choice.

Table Exports
The Export link in the Table view brings up the export sub-panel for a specific table. It
is similar to the database export panel, but there is no table selector. However, there is
an additional section for split exports before the Save as file sub-panel.