What db table does TablePress saves the tables

Hi,

thanks for your post, and sorry for the trouble.

TablePress stores the table data as JSON-encoded two-dimensional arrays in the wp_posts database table. The table settings/options are stored in the wp_postmeta table. Finally, general settings are stored in wp_options.

Due to this, to transfer everything cleanly, I strongly recommend to use the TablePress Export and Import features. First, export all tables in the JSON format to a ZIP archive on the old site, and import that file on the new site. This allows moving all tables while even preserving their table IDs. Finally, you’d need to manually copy/paste the “Custom CSS” from the “Plugin Options” screen, if there’s any.

Regards,
Tobias

Thanks.
Due to some of the options, such as featured images not transferring correctly and possible timeouts when exporting a large amount of posts using the WordPress tool, I’m starting with a new new clean installation of WordPress, but I’m importing the some of the tables to the new database, such as:
wp_posts
wp_comments
wp_terms
wp_commentmeta
wp_postmeta
wp_term_relationships
wp_term_taxonomy
wp_termmeta

And then I’m reconfiguring the rest from scratch.

So, I’m bringing these tables to the new database, the only thing left would be configuring the general options with TablePress, correct?

Thanks,

Hi,

yes, that should work. From the wp_options table, you’d need the tablepress_tables and tablepress_options entries.

Regardless, I recommend to make a backup of all your tables by exporting them to a ZIP archive of JSON files, as mentioned above.

Regards,
Tobias

Thanks,

Hi,

no problem, you are very welcome! ?? Good to hear that this helped!

Best wishes,
Tobias

P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!

Doesn’t the export takes a lot of resource for about 200 tables? I’m asking because I’m transferring the site because of some mysql performance issue, and I’m trying not poke the db too hard.
Thanks,

Hi,

no, I don’t think so. And it’s a one time thing, so not really that much load.

Regards,
Tobias

@tobiasbg
Ok, so when I transferred the wp_posts and wp_postmeta and downloaded the TablePress plugin, none of the tablets show up in the plugin. So the questions are, if I export a backup from the old site, and import it back to new database where I have already imported the wp_posts and wp_postmeta tables from the old site, what’s going to happen to the existing tablepress tables already in the database, which currently the plugin doesn’t see? Are there going to be duplicate tables inside of the database? Will they get overwritten? the backup will look into the able find the tables and show them up in the plugin? What’s going to happen?

Also, I see that it’s possible to export all or some of the tables, can I create backups in chucks? I mean can backup 20 tables, restore them, backup the next 20, and then restore and expect that at the end all the tables will show up in the new site?

Thanks,

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

Hi,

TablePress is not seeing these entries in the wp_posts and wp_postmeta database table, because their “connection” to a table ID is missing. That’s stored in the mentioned wp_options entry.

I recommend to delete the entries from wp_posts and wp_postmeta again, as TablePress will not pick them up when importing the tables again. They would be left as useless duplicates.

And yes, you could easily do that export/import routine in chunks of e.g. 20 tables per run.

Regards,
Tobias

@tobiasbg I don’t use phpmyadmin, just the mysql console, so how can I delete the tablepress entries from the wp-posts and wp_postmeta? and specific entries I have to delete? Thanks,

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

Hi,

you can find them in the wp_posts table by searching for tablepress_table in the post_type database column. There, note the ID (or post_ID) column (I don’t remember the correct name right now.) In the wp_postmeta table, you can find the entries by those post IDs.

Note that you could also try moving over the mentioned tablepress_tables and tablepress_options entries in the wp_options DB table. Maybe that already helps as it could restore everything already.

Regards,
Tobias

Now I’m thinking that transfering the tablepress_tables and tablepress_options from the wp_options by any chance don’t know the mysqldump syntax to export those entries?
thank you so much.

Hi,

sorry, I’m not familiar with mysqldump and can’t help with that. It’s definitely easier with phpMyAdmin or similar tools.

Regards,
Tobias

Ok. What’s the actually technical name for tablepress_tables and tablepress_options inside of a table? row, cell, column? I need to know so I can research a solution. Thanks,

Hi,

I’m not sure that I understand. tablepress_tables and tablepress_options are the values that the two database table rows have in the option_name column of the wp_options database table.

Regards,
Tobias