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!