1. Home
  2. Docs
  3. Data Explorer
  4. Transfer to other WP database

Transfer to other WP database

Attended as well as scheduled unattended exports (data backup) 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.

Manually updating database names

When data is transferred from one server to another using an external tool, database names have to be updated manually. Please download the following SQL code to help you to rename your database names.

> Download code (please read the README before you start)

Using external tools

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 2 No

Leave a Reply

Your email address will not be published.