Databases Reference
In-Depth Information
Exporting a table
The
Export
link in the
Table
view brings up the export sub-panel for a specific table.
It is similar to the database export panel, but there is no table selector. However,
there is an additional section for split exports (
Rows
) before the
Output
sub-panel, as
depicted here:
Split-file exports
The part of the dialog containing
Number
of
rows
and
Row
to
begin
at
enables us
to split the table into chunks. Depending on the exact row size, we can experiment
with various values for the number of rows to find and 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 such as
book00.sql
and
book01.sql
for our
export files. Should we decide to export all rows, we just select the
Dump
all
rows
radio button.
Exporting selectively
At various places in phpMyAdmin's interface, we can export the results that we
see, or select the rows that we want to export. We will examine the various ways of
exporting a selected portion of a table.
Search WWH ::
Custom Search