According to the current context, the resulting export's scope will be a
complete database, a single table or even, in the case of Server view, a
multi-database export. We will first explain database exports and all the
relevant export types, and then we'll go on with table and multi-database
exports, underlining the difference for these modes of exporting.
Database Exports
In Database view, click the Export link. The default export panel looks like this:
Chapter 7
[ 117 ]
The default values selected here depend on config.inc.php, more specially
specifically on the $cfg['Export'] array of parameters. For example, the
$cfg['Export']['format'] parameter is set to 'sql' so that the SQL export mode
is chosen by default.
The export panel has three sub-panels. The top panel Export and the bottom panel
Save as file are always there, and the third panel varies (using dynamic menu
techniques) so as to show the options for the export mode chosen (which is SQL here).
The Export Sub-Panel
This sub-panel contains a table selector, where we choose the tables and the format
that we want. The SQL format is useful, for our needs, since it creates standard SQL
commands that would work on any SQL server. Other possible formats include
LaTeX, PDF, Microsoft Excel 2000, Microsoft Word 2000, Comma-Separated Values
(CSV), YAML, Open Document Spreadsheet, Open Document Text, and XML.
Pages:
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126