1. Home
  2. Docs
  3. Index
  4. Data Explorer
  5. Export and import

Export and import

WP Data Access offers two types of exports and imports:

  1. Data Explorer main page export and import
  2. Data Explorer table page export and import

 

Data Explorer main page export/import

Use these features to export/import tables. The SQL export file includes a create table statement for every exported table and an insert into statement for every exported row.

Export table(s)

To export multiple tables at ones, select the desired tables, select Export Table from the Bulk Actions list and click Apply. This feature supports export to SQL1) only.

To export a single table, click on the Manage link for the desired table and click on the Export button on the Actions tab. This feature supports export to SQL1), XML, JSON, Excel and CSV.

Import table(s)

Click the “Import data/Execute script(s)” button at the top of the screen. Select the file you want to import and click Import File.

 

Data Explorer table page export/import

Use these features to export/import a selected number of rows from a specific table. The export file includes an insert into statement for every exported row. 2)

Export table data

Use the search box to find the rows you want to export. If not all rows you want to export are visible, click on Screen Options (upper right corner of the page) and change Number of items per page accordingly. Select the rows you want to export. Select Export from the Bulk Actions list and click Apply. This feature supports export to SQL1), XML, JSON, Excel and CSV.

Import table data

Click the import button on top of the screen. Select the file you to import and click Import File.

 

NOTES

  1. Export to SQL offers support for seemless export and import between WordPress databases that use different prefixes. The WordPress table prefix is replaced during export by variable {wp_prefix}, which is replaced by the WordPress table prefix on import. If you want to use another tool for import, disable checkbox “Export with variable WP prefix” in Back-End Settings on the Manage Plugin page. With “Export with variable WP prefix” disabled full table names will be written to the export file. (read more…)
  2. The import feature on a Data Explorer table page only supports the import of data into the table displayed on the page. Any other statement than an insert into the table on the page will be rejected. Use the import feature of the Data Explorer main page to import any valid import file.

Was this article helpful to you? Yes No

Leave a Reply

Your email address will not be published. Required fields are marked *