Hey there, Awesome Customers!

Just a heads up: We'll be taking a breather to celebrate International Workers' Day (May 1st and 2nd - Wednesday and Thursday) and Orthodox Easter from Good Friday (May 3rd) through Easter Monday (May 6th). So, from May 1st to May 6th, our team will be off enjoying some well-deserved downtime.

During this time, our customer support will be running on a smaller crew, but don't worry! We'll still be around to help with any urgent matters, though it might take us a bit longer than usual to get back to you.

We'll be back in action at full throttle on May 7th (Tuesday), ready to tackle your questions and requests with gusto!

In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find loads of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel). These gems might just have the answers you're looking for while we're kicking back.

Thanks a bunch for your understanding and support!

Catch you on the flip side!

Warm regards,

TMS

Okay
  Public Ticket #2454276
backing up wptablesdata out of mysql
Closed

Comments

  • Roy started the conversation
    June 26, 2020 at 4:26pm

    I have to backup my data out of my wp backend.

    My site (mysql) database causes some plugin problems and the siteground admins cant find the problem, database shows no errors.

    They suggest to start all over again. 

    Ok, that is no problem but how do i backup my WPDatatables data, 3 years of hard work in there, and not the rest of the mysql database.
    How do i backup the settings and css styles.

    Please help i dont know how to do this.

    Roy

  •  2,498
    Aleksandar replied
    June 29, 2020 at 9:15am

    Hello Roy

    Other than cloning the site, another option would be to copy all database tables (wp_wpdatatable_#) along with tables wp_wpdatatables, wp_wpdatacharts 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.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables