We are about to roll out the wpDataTables table we customised on all our product pages. Before we commit to that, we want to clarify two things:
- how can we backup our wpDataTables? If, for instance, we need to re-install wpDataTables or even Wordpress itself, how can we get our custom tables back online quickly? Where are the definitions saved, what is the tried and proven way to do this?
- How do upgrades (especially of Wordpress itself) affect wpDataTables and our custom tables? Are they "upgrade-safe"?
I tried to find answers to those questions in the documentation and forums, but didn´t. So thank you for replying here!
The tables' settings are stored in wp_wpdatatables_columns table.
The best way to back up everything would be to install the Duplicator Plugin, which will clone your entire website - all the files and also the tables from the database. Then, if something goes wrong, you can simply use the two files created by that plugin to restore your website.
Updates don't usually affect the plugin. Due to WordPress' nature, though, there is always a possibility that when another plugin updates, it can cause a conflict with wpDataTables.
My employer asked the following: imagine the scenario that wpDatatables be completely removed from the website, and needs to be re-installed clean. What is the quickest/best way to get back the necessary tables (and everything else we need)?
Reverting the entire website using Duplicator is not something he likes as a solution. That has a bigger scope, too: what if we want to use wpDatatables and our custom tables (developed with a lot of effort) on a different website? How do we get them there? What needs to be copied?
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.
Hi guys,
We are about to roll out the wpDataTables table we customised on all our product pages. Before we commit to that, we want to clarify two things:
- how can we backup our wpDataTables? If, for instance, we need to re-install wpDataTables or even Wordpress itself, how can we get our custom tables back online quickly? Where are the definitions saved, what is the tried and proven way to do this?
- How do upgrades (especially of Wordpress itself) affect wpDataTables and our custom tables? Are they "upgrade-safe"?
I tried to find answers to those questions in the documentation and forums, but didn´t. So thank you for replying here!
Hi again Florian
The tables' settings are stored in wp_wpdatatables_columns table.
The best way to back up everything would be to install the Duplicator Plugin, which will clone your entire website - all the files and also the tables from the database. Then, if something goes wrong, you can simply use the two files created by that plugin to restore your website.
Updates don't usually affect the plugin. Due to WordPress' nature, though, there is always a possibility that when another plugin updates, it can cause a conflict with wpDataTables.
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
Hi Aleksandar,
another question regarding backup security.
My employer asked the following: imagine the scenario that wpDatatables be completely removed from the website, and needs to be re-installed clean. What is the quickest/best way to get back the necessary tables (and everything else we need)?
Reverting the entire website using Duplicator is not something he likes as a solution. That has a bigger scope, too: what if we want to use wpDatatables and our custom tables (developed with a lot of effort) on a different website? How do we get them there? What needs to be copied?
Thank you again
Florian
Hi again Florian.
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:
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