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.