Export ¶

CodeGen¶

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

CSV¶

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

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.

Microsoft Word 2000¶

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

JSON¶

JSON (JavaScript Object Notation) is a lightweight data-interchange format. It is easy for humans to read and write and it is easy for machines to parse and generate.

The generated JSON is list of objects with following attributes:

type¶

Type of given object, can be one of:

header

Export header containing comment and phpMyAdmin version.

database

Start of a database marker, containing name of database.

table

Table data export.

version¶

Used in header type and indicates phpMyAdmin version.

comment¶

Optional textual comment.

name¶

Object name - either table or database based on type.

database¶

Database name for table type.

data¶

Table content for table type.

Sample output:

[     {         "comment": "Export to JSON plugin for PHPMyAdmin",         "type": "header",         "version": "4.7.0-dev"     },     {         "name": "cars",         "type": "database"     },     {         "data": [             {                 "car_id": "1",                 "description": "Green Chrysler 300",                 "make_id": "5",                 "mileage": "113688",                 "price": "13545.00",                 "transmission": "automatic",                 "yearmade": "2007"             }         ],         "database": "cars",         "name": "cars",         "type": "table"     },     {         "data": [             {                 "make": "Chrysler",                 "make_id": "5"             }         ],         "database": "cars",         "name": "makes",         "type": "table"     } ] 

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 od TeX.

The output needs to be embedded into a LaTeX document before it can be rendered, for example in following document:

\documentclass{article} \title{phpMyAdmin SQL output} \author{} \usepackage{longtable,lscape} \date{} \setlength{\parindent}{0pt} \usepackage[left=2cm,top=2cm,right=2cm,nohead,nofoot]{geometry} \pdfpagewidth 210mm \pdfpageheight 297mm \begin{document} \maketitle  % insert phpMyAdmin LaTeX Dump here  \end{document} 

MediaWiki¶

Both tables and databases can be exported in the MediaWiki format, which is used by Wikipedia to display tables. It can export structure, data or both, including table names or headers.

OpenDocument Spreadsheet¶

Open standard for spreadsheet data, which is being widely adopted. Many recent spreadsheet programs, such as LibreOffice, OpenOffice, Microsoft Office or Google Docs can handle this format.

OpenDocument Text¶

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

PDF¶

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

PHP Array¶

You can generate a php file which will declare a multidimensional array with the contents of the selected table or database.

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".

Texy!¶

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

XML¶

Easily parsable export for use with custom scripts.

YAML¶

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