export

From PmaWiki

phpMyAdmin can export into text files (even compressed) on your local disk (or a special the webserver "SaveDir" folder) in various commonly used formats:

Contents 1 CodeGen 2 CSV 3 CSV for Microsoft Excel 4 Microsoft Excel 2000 5 Microsoft Word 2000 6 LaTeX 7 OpenDocument Spreadsheet 8 OpenDocument Text 9 PDF 10 SQL 11 Native Microsoft Excel 12 Texy! 13 XML 14 YAML

[edit] CodeGen

This feature is available since phpMyAdmin 3.0.0.

NHibernate file format. Planned versions: Java, Hibernate, PHP PDO, JSON, etc. So the preliminary name it codegen.

[edit] CSV

Comma separated values format which is often used by spreadsheets or various other programs for export/import.

[edit] CSV for Microsoft Excel

This is just preconfigured version of CSV export which can be imported into Microsoft Excel.

[edit] Microsoft Excel 2000

If you're using Microsoft Excel 2000 or newer (or compatible such as OpenOffice.org), you can use this export.

[edit] Microsoft Word 2000

If you're using Microsoft Word 2000 or newer (or compatible such as OpenOffice.org), you can use this export.

[edit] LaTeX

If you want to embed table data or structure in LaTeX, this is right choice for you.

LaTeX is a typesetting system that is very suitable for producing scientific and mathematical documents of high typographical quality. It is also suitable for producing all sorts of other documents, from simple letters to complete books. LaTeX uses TeX as its formatting engine. Learn more about TeX and LaTeX on the Comprehensive TeX Archive Network (also see the short description of TeX).

The output needs to be embedded into a LaTeX document before it can be rendered. See an example LaTeX document.

[edit] OpenDocument Spreadsheet

This feature is available since phpMyAdmin 2.9.0.

New standard for spreadsheet data which is being widely addopted. Most recent spreadsheet programs (such as OpenOffice.org or KSpread) can handle this.

[edit] OpenDocument Text

This feature is available since phpMyAdmin 2.9.0.

New standard for text data which is being widely addopted. Most recent word processors (such as OpenOffice.org, AbiWord or KWord) can handle this.

[edit] PDF

For presentation purposes, non editable PDF might be best choice for you.

[edit] SQL

Export in SQL can be used to restore your database, thus it is useful for backing up.

[edit] Native Microsoft Excel

This export requires PEAR module Spreadsheet_Excel_Writer and uses it to create native Microsoft Excel files.

[edit] Texy!

This feature is available since phpMyAdmin 3.0.0.

Texy! markup format. You can see example on Texy! demo.

[edit] XML

Easily parsable export for use with custom scripts.

[edit] YAML

This feature is available since phpMyAdmin 2.11.0.

YAML is a data serialization format which is both human readable and computationally powerful ( http://www.yaml.org ).