Hi,
thanks for your question, and sorry for the trouble.
TablePress tables are stored as entries in the wp_posts database table. You’ll recognize them by looking for entries with the value tablepress_table in the post_type field. In addition, their settings and meta data is stored in the wp_postmeta table.
Due to this, I don’t recommend to directly migrate mySQL DB entries. Instead, I recommend to use the export/import feature (preferably with the JSON format) to move tables.
Regards,
Tobias
Hi Tobias,
Thanks for the info.
So would the easiest way be to save the Live site’s entries with the value tablepress_table outside my WP installation (but still in my hosting account) and then copy them back into that folder once I’ve migrated the Development site from the staging area, please?
By the way, when I created the dev site I simply let the plugin copy everything over, including the tables, and they appear to work okay. Maybe the migration plugin is a really good one and really can handle this stuff!
Thanks,
Steve
Hi Steve,
yes, this should be a good strategy. If however the size of the tables or the settings on their “Edit” screen changed, you should also do the same for the entries in the wp_postmeta table.
In all cases, make sure to have backups of both sites’ tables, e.g. by exporting them to a ZIP archive with the tables in JSON format.
Regards,
Tobias
Thanks, Tobias. Enjoy the rest of your weekend.
Hi,
no problem, you are very welcome! 🙂 Good to hear that this helped!
Best wishes and a nice weekend, too!
Tobias
P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!
