WP Data Access
  • Download
  • Support
  • Features
  • Pricing
  • Documentation
Select Page
Popular Search formimportsqlqueryshortcode

WP Data Access

  • Getting started
  • Installation
  • What’s new?
  • Patches
  • Known limitations
  • FAQ

Data Tables

  • Getting Started
  • Creating and publishing
  • Responsive data tables
  • SEO friendly data tables
  • Adding hyperlinks
  • Extension Manager
  • Style Manager
  • Language settings
Styling
  • Style Manager
  • Premium styling
  • Global styling
  • Code Manager Styling
  • Manual styling
  • Styling issues
Filters
  • Static filters
  • Interactive filters
    • URL parameters
    • Search Panes
    • Search Builder
    • Search form
    • Advanced search
    • Geolocation search
Export & other buttons
  • Export to PDF, CSV, Excel, SQL
  • Print & copy buttons
  • Column selection buttons
  • Custom buttons
Advanced features
  • Advanced settings
  • Large tables & performance
  • Progressively SHOW MORE
  • Custom queries
  • Custom Post Types
  • Row grouping
  • Responsive master-detail
  • Master-detail tables
  • Non admin user access
Demos & tutorials
  • Demos
  • Tutorials

Data Apps

  • Data Projects
  • Projects and templates
  • Supported Data Types
  • One-To-Many relationships
  • Many-To-Many relationships
  • Registration page
  • Manage table options
  • Shortcode usage
Project Templates
  • Project Templates
  • Creating templates
  • Table Settings
  • Relationships
  • List Table
  • Data Entry
  • Reconcile
Data Forms
  • Data Forms
  • Overview
  • Project Demo
  • Page Demo
Advanced features
  • Adding filters
  • Custom validation
  • Add less/more button
  • User roles
  • Managing roles and users
  • Advanced table options
  • Advanced lookups
  • Front-end toolbar
  • Transfer to other WP site
Demos & tutorials
  • Demos
  • Tutorials

Data Explorer

  • Getting started
  • Navigation
  • Explore tables & views
  • Manage tables & views
  • Naming conventions
Manage Actions
  • Actions
Manage Settings
  • Settings
  • Table Settings
  • Column Settings
  • Search Settings
  • Geolocation Settings
  • Dynamic Hyperlinks
  • Dashboard Menus
Data Management
  • Import CSV & SQL files
  • Run SQL script files
  • Data Backup
Problems & solutions
  • InnoDB #rows estimation
  • Import file too large
  • Transfer to other WP DB

Remote Databases

  • MySQL | MariaDB
Other DBMS
  • Heterogeneous Connections
  • Using ODBC | JDBC
  • Connect to SQL Server
Premium Data Services
  • Remote wizard
  • START HERE
  • Errors and messages
  • Limitations
  • Tutorials
  • Remote Databases
    • Remote databases
    • SQL Server
    • PostgreSQL
    • Oracle
    • MariaDB | MySQL
    Remote Data Files
    • Remote data files
    • CSV files
    • JSON files
    • MS Access
    • XML files
    • Public URL
    • Synchronization
    Advanced features
    • Performance
    • Indexes

SQL

  • Getting Started
  • Tutorials
  • Visual Query Builder
  • Writing queries
  • Data exchange
  • Stored procedures
  • Database triggers
  • Scheduled queries

Business Intelligence

  • Getting started
  • Dashboards
  • Sharing dashboards
Dashboards Widgets
  • Dashboard Widgets
  • Publication Widget
  • Project Widget
  • Chart Widget
  • Custom Code Widget
  • Database Widget
  • Sharing Widgets

Table Design

  • Getting started
  • Introduction
  • Basic mode

Plugin Settings

  • Getting started
  • Plugin
  • Back-end
  • Front-end
  • Dashboard
  • Data Forms
  • Data Tables
  • Data Backup
  • Uninstall
  • Manage Repository
  • Manage Roles
  • System Info

Code

Shortcodes
  • Overview
  • wpdataaccess
  • wpdadataproject
  • wpdadataforms
  • wpdadiehard
  • wpdageomap
  • wpdawidget
Plugin Variables
  • WordPress user ID in SQL
  • Environment variables
Hooks & filters
  • Overview
  • Hooks
    • Overview
    • wpda_add_search_actions
    • wpda_add_search_filter
    • wpda_before_list_table
    • wpda_after_list_table
    • wpda_wpdataaccess_prepare
    Filters
    • Overview
    • wpda_column_default
    • wpda_before_simple_form
    • wpda_after_simple_form
    • wpda_construct_where_clause
API
  • WP Data Access API
  • Remote database access
  • CRUD Example
  • Extensions
    • Alternative search algorithm
    • Alternative buttons extension
Code Manager
  • Overview
  • Write code
  • Share(d) code

Transfer to other WP DB

Table of Contents
  • Manually updating database names after external import
    • Preparation
    • Execution
    • Notes
  • Prepare exports for external tools usage

Attended as well as scheduled unattended exports to SQL allow plugin users to exchange tables 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}. The prefix is replaced by the WordPress table prefix of the WordPress destination database on import.

WP Data Access - Export Flow

Manually updating database names after external import #

When you transfer tables using another tool, you need to update the database names manually. The following SQL code renames the database names in all WP Data Access repository tables.

Preparation #

  • Copy the SQL code below to your clipboard
  • Paste the code into an editor
  • Enter your old database name (replace text: enter-your-old-db-name-here)
  • Enter your new database name (replace text: enter-your-new-db-name-here)
  • Replace the default WordPress table prefix if not wp_ (DO THIS FOR ALL UPDATES)
  • Copy the whole editor content to your clipboard

Execution #

  • Start WP Data Access
  • Open the Query Builder
  • Paste the code from your clipboard into your Query Builder
  • Execute the code

Notes #

  • You can use this procedure to update multiple database names. Just make sure you change the old and new database names correctly before you execute.
  • You can save this code in your Query Builder for future use.
set @old_db_name = 'enter-your-old-db-name-here'
/
set @new_db_name = 'enter-your-new-db-name-here'
/

update wp_wpda_publisher set pub_schema_name = @new_db_name where pub_schema_name = @old_db_name
/
update wp_wpda_project_page set page_schema_name = @new_db_name where page_schema_name = @old_db_name
/
update wp_wpda_project_table set wpda_schema_name = @new_db_name where wpda_schema_name = @old_db_name
/
update wp_wpda_media set media_schema_name = @new_db_name where media_schema_name = @old_db_name
/
update wp_wpda_menus set menu_schema_name = @new_db_name where menu_schema_name = @old_db_name
/
update wp_wpda_table_design set wpda_schema_name = @new_db_name where wpda_schema_name = @old_db_name
/
update wp_wpda_table_settings set wpda_schema_name = @new_db_name where wpda_schema_name = @old_db_name
/
  • Or download ZIP file including code and instructions

Prepare exports for external tools usage #

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.
Share This Article :
  • Facebook
  • Twitter
  • LinkedIn
  • Pinterest
Still stuck? How can we help?

How can we help?

Updated on 2022-12-13
Import file too large

Submit a Comment Cancel reply

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

Table of Contents
  • Manually updating database names after external import
    • Preparation
    • Execution
    • Notes
  • Prepare exports for external tools usage

Links

Blogs
Tutorials
Demos

Socials

LinkedIn
Twitter

Get in touch

Premium support
Free support forum
Contact us

Resources

WordPress plugin directory
YouTube tutorials

Passionate Programmers B.V. © 2017 - 2023 All rights reserved