Databases Reference
In-Depth Information
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
books00.sql
and
books01.sql
for our export files.
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 topics from
author_id 2
- an
Export
link appears at the bottom of the page:
Search WWH ::
Custom Search