Hello Bk Kalia.

Thank you for your purchase.

When you are moving your website, we can suggest using the Duplicator plugin. We use it and it's working fine, because it will transfer all the files and also the tables to the new database. 

Hey Kalia

Sorry for the late response, we're not working on weekends.

Well the thing is that you can export the manual tables created in the database easily (they are entitled wp_wpdatatable_#, where wp_ is your database prefix, and # the corresponding table ID).

However, all other tables (linked to an existing data source) store information in a few places:

wp_options

wp_wpdatacharts

wp_wpdatatables

wp_wpdatatables_columns

Mostly it is saved in the wp_wpdatatables_columns table, but the configuration is linked to the table ID from the plugin, so you may need to recreate them in the same order in which you created them here. You can copy those tables, but I can't guarantee that all of them will work after you transfer them to a new database.

Hello Dominic.

We're sorry to see you were unable to migrate tables from wpDataTables to another site. This, of course, can be done but at the time it requires some additional work.

Other than cloning the site, another option would be to copy all database tables (wp_wpdatatable_#) along with tables wp_wpdatatables, wp_wpdatacharts, wp_wpdatatables_rows and wp_wpdatatables_columns. Then, in wp_options table, you would also need to export the following option_names:

• wdtPreventDeletingTables
• wdtUseSeparateCon
• wdtSeparateCon
• wdtTimepickerRange
• wdtTimeFormat
• wdtTabletWidth
• wdtTablesPerPage
• wdtSumFunctionsLabel
• wdtRenderFilter
• wdtRenderCharts
• wdtIncludeBootstrap
• wdtIncludeBootstrapBackEnd
• wdtPreventDeletingTables
• 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

It is rather cumbersome to do all this, but unfortunately at the moment, it's the only way. Also, for tables linked to an existing data source, you would need to change the file path, because at the moment the file path depends on the domain, so if you change the domain, the URL to the file will also have to be changed.

Our developers are working on creating an "Export" function, so this will be much simpler in the future.

Hi Alejandro,

We are double-checking this with our Senior Team and our QA to confirm it for you.

As far as i can see, yes, you should simply export all of these options that start with the "wdt", but we are double-checking.

Going to report back as soon as possible.

Thank you for your patience.

Hi Alejandro,

We got feedback from our QA Team, they explained how that works.

Basically, all these additional options you found, they are automatically 'filled in' based on your other settings in the Plugin.

So if we were to run the same SQL Query as you did on our Database, we would get all the same data, just probably some options would be differently 'set' / 'filled out', depending how we configure our settings in the Plugin, and if we activate a licence or not, etc, such as for example wdtNumberFormat, wdtTablesPerPage, Custom css, json and similar.

All these settings are being populated when the Plugin gets installed on WordPress.

The main/most important options have been listed by colleague Aleksandar in the previous response;

all these other/additional options are going to get 'populated' automatically based on how you will use the Plugin, but there should be no harm if you export them all, so you can freely do so if you wish, they should just get populated either way, if that makes sense.

I hope that clarifies everything, but let us know how it goes when you do the migration and if you have any additional questions.

Thank you.