Support » Plugin: TablePress » Where are tables stored

  • Resolved StevenW123

    (@stevenw123)


    Hi Tobias,

    I want to replace a live site with one I’ve been developing in a staging area. Where are the tables stored in Tablepress, please? If possible, I’d like to transfer the dev site without overwriting the tables in the live one, so I don’t have to import some of them again.

    Thanks,
    Steve

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author TobiasBg

    (@tobiasbg)

    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

    Plugin Author TobiasBg

    (@tobiasbg)

    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.

    Plugin Author TobiasBg

    (@tobiasbg)

    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!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Where are tables stored’ is closed to new replies.