---
title: "How to Properly Migrate wpDataTables Between Sites"
description: "Steps to move your tables and settings without issues."
url: https://help.wpdatatables.com/en/articles/42-how-to-properly-migrate-wpdatatables-between-sites
collection: "FAQ"
updated: 2026-09-15
language: en
---

# How to Properly Migrate wpDataTables Between Sites

Steps to move your tables and settings without issues.

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](https://wordpress.org/plugins/duplicator/)
    
-   [All-in-One WP Migration](https://wordpress.org/plugins/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](https://help.wpdatatables.com/en/articles/31-manual-or-linked-wpdatatables-not-showing-after-migration.md)

* * *

📤 **Exporting Individual Tables**  
If you're migrating just a few tables, you can try the built-in [Table Tools](https://wpdatatables.com/documentation/table-features/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!