Transfer to other WordPress database

Attended as well as scheduled unattended exports to SQL offer support for seemless export and import between WordPress databases that use different table prefixes. The WordPress table prefix of the WordPress source database is replaced during export by environment variable {wp_prefix}. This environment variable is replaced by the WordPress table prefix of the WordPress destination database on import.

Follow these steps if you want to use another tool (like MySQL command line or phpMyAdmin) to import Data Explorer export files:

  • Navigate to the Manage Plugin page (tab Back-End Settings)
  • Disable checkbox “Export with variable WP prefix”

With “Export with variable WP prefix” disabled full table names are written to the export file.

Was this article helpful to you? Yes No