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 |
[edit] CodeGen
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 most english versions of Microsoft Excel. Some localised versions (like "Danish") are expecting ";" instead of "," as field separator.
[edit] Microsoft Excel 97-2003 (XLS)
If you're using Microsoft Excel 2000 (97 with compatibility patches should also work) or newer (or compatible such as OpenOffice.org), you can use this export.
NOTE: As of phpMyAdmin version 3.3.0, no external library (PEAR Spreadsheet_Excel_Writer module) is required. Rather, the necessary files are bundled with phpMyAdmin.
[edit] Microsoft Excel 2007 (XLSX)
If you're using Microsoft Excel 2007 or newer (or compatible such as OpenOffice.org), you can use this export.
NOTE: Older version of Excel can utilize this format if you install the appropriate compatibility update.
[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
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
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.
The option 'Maximal length of created query' seems to be undocumented. But experiments has shown that it splits large extended INSERTS so each one is no bigger than the given number of bytes (or characters?). Thus when importing the file, for large tables you avoid the error "Got a packet bigger than 'max_allowed_packet' bytes". See http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html
[edit] Texy!
Texy! markup format. You can see example on Texy! demo.
[edit] XML
Easily parsable export for use with custom scripts.
NOTE: The XML schema used has changed as of version 3.3.0
[edit] YAML
YAML is a data serialization format which is both human readable and computationally powerful ( http://www.yaml.org ).
