Export table to another site bulkly

  • Resolved seotaro

    (@seotaro)


    1 year, 9 months ago

    Hi there. I’m building a multilingual homepage and would like to move tables from my existing website to the new site in bulk.

    I searched your post and saw that the table contents are stored in the DB.

    So do I just export all tables starting with wp_wpdatatables from the DB and then import them in the new DB?

    Thank you.

Viewing 1 replies (of 1 total)
  • Plugin Author wpDataTables

    (@wpdatatables)

    Hello.
    We will do our best to advise you on the recommended ways how you can move the plugin data from one site to another.

    When you are moving on live site from local or stage site (or vice-versa) we can suggest using Plugin Duplicator. We use it and it’s working fine because it will transfer all the files and also the tables to the database. 

    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. 

    Important to note, 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 will be working on adding an easier solution to export everything, but we can’t say an ETA on this.

    Kind regards.

    • This reply was modified 1 year, 9 months ago by wpDataTables.
Viewing 1 replies (of 1 total)
  • The topic ‘Export table to another site bulkly’ is closed to new replies.