What db table does TablePress saves the tables

It’s a little clear now. However, using the this command: select option_name from wp_options; I see different values including: tablepress_plugin_options and tabletpress_tables.

Hi,

ah, yes, sorry. tablepress_plugin_options and tablepress_tables are the correct names. I remembered the wrong names in my previous replies.

Regards,
Tobias

@tobiasbg Thanks for the clarification. Since this is getting more complicated than anticipated, I was wondering if when clicking the uninstall button from within the plugin will actually delete everything, settings and tablets, from the database without leaving anything behind?

I was thinking that I can close the server, use the uninstall button from Tablepress, then backup the tables I need to run WordPress without tablepress, and then restore WordPress table, reinstall tablepress and then restore the tablapress tables from the exported backup.

Second solution:
Also, out of curiosity, in the new site, where currently I can’t see the tablepress tables, if I install the plugin and I click the Uninstall button, will it delete the tables too? Or it needs tablepress_plugin_options and tablepress_tables in order to find and delete the tables from the wp_posts table?

Thanks,

• This reply was modified 4 years, 5 months ago by wpmhweb.

Hi,

for your second solution first:
No, this won’t work. TablePress needs the tablepress_plugin_options and tablepress_tables information when uninstalling.

For your first solution:
Yes, you could probably do it like that (if you still have full backups of everything), but it still sounds totally complicated.
You will really only need to move over tablepress_tables and tablepress_plugin_options at the current stage, which can be done with e.g. phpMyAdmin or a direct SQL query on the command line.

Alternatively, install and activate https://tablepress.org/download/extension/tablepress-debug.zip as a new plugin on your site. Then, in the “TP Tables” menu, delete all tables (this is the raw table data).
After that, import the mentioned JSON export files, that I described above.

Regards,
Tobias