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.
Split-File Exports
The Dump 3 row(s) starting at record # 0 dialog enables us to split the file into
chunks. Depending on the exact row size, we can experiment with various values for
the number of rows to find how many rows can be put in a single export file before
the memory or execution time limits are hit in the web server. We could then use
names like book00.sql and book01.sql for our export files.
Exporting Structure and Data
[ 134 ]
Selective Exports
At various places in phpMyAdmin's interface, we can export the results that we see,
or we can select the rows that we want to export.
Exporting Partial Query Results
When results are displayed from phpMyAdmin??”here the results of a query asking
for the books from author_id 2??”an Export link appears at the bottom of the page:
Chapter 7
[ 135 ]
Clicking on this link brings up a special export panel containing the query on the top
along with the other table export options:
The results of single-table queries can be exported in all the available
formats, while the results of multi-table queries can be exported only in
CSV, XML, and LaTeX formats.
Exporting and Checkboxes
Anytime we see results (when browsing or searching, for example), we can check
the boxes beside the rows that we want, and use the With selected: export icon to
generate a partial export file with just those rows.
Pages:
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141