How to Properly Migrate wpDataTables Between Sites

When migrating your site — whether from a local or staging environment to a live domain (or vice versa) — we recommend using one of the following methods:

Recommended Method: Full Site Migration Plugin
Use one of these trusted WordPress migration plugins:

• Duplicator

• All-in-One WP Migration

These tools handle both files and database entries and work reliably with wpDataTables. We use them ourselves.

Manual Method: Copy Database Tables and Options
If you’re not cloning the full site, you can migrate wpDataTables manually by copying:

1. Database tables:

• wp_wpdatatable_# (all tables with this prefix)

• wp_wpdatatables

• wp_wpdatacharts

• wp_wpdatatables_rows

• wp_wpdatatables_columns

Note: Future updates may introduce new tables under the same prefix — so copy any you find with wp_wpdatatable_#.

2. wp_options entries (option_name):

• wdtPreventDeletingTables

• wdtUseSeparateCon

• wdtSeparateCon

• wdtTimepickerRange

• wdtTimeFormat

• wdtTabletWidth

• wdtTablesPerPage

• wdtSumFunctionsLabel

• wdtRenderFilter

• wdtRenderCharts

• wdtIncludeBootstrap

• wdtIncludeBootstrapBackEnd

• wdtParseShortcodes

• wdtNumbersAlign

• wdtBorderRemoval

• wdtBorderRemovalHeader

• wdtNumberFormat

• wdtMobileWidth

• wdtMinifiedJs

• wdtMinFunctionsLabel

• wdtMaxFunctionsLabel

• wdtLeftOffset

• wdtTopOffset

• wdtInterfaceLanguage

• wdtGeneratedTablesCount

• wdtFontColorSettings

• wdtDecimalPlaces

• wdtCSVDelimiter

• wdtDateFormat

• wdtCustomJs

• wdtCustomCss

• wdtBaseSkin

• wdtAvgFunctionsLabel

• wdtInstallDate

• wdtRatingDiv

• wdtMDNewsDiv

• wdtTempFutureDate

Just like with tables, if future versions introduce new options with the wdt prefix, make sure to include them as well.

External Files and Linked Tables
If your tables are linked to external files (like Excel or CSV), you’ll need to update the file paths after migration. These paths are domain-specific.

If you run into issues with linked tables after moving the site, follow this guide:
Manual or Linked wpDataTables Not Showing After Migration

Exporting Individual Tables
If you're migrating just a few tables, you can try the built-in Table Tools to export them one by one.

Our developers are working on a built-in export/import feature for smoother migrations in the future — but we don’t have an ETA yet.

If you have any questions, feel free to reach out via the support chat!