Support » Plugin: TablePress » What db table does TablePress saves the tables

  • Resolved wpmhweb

    (@wppit)


    I’m transferring the site to another server cleanly, so I’m reconfiguring the TablePress again, but I would like to know in which table does TablePress saves the data before I export the settings.
    is it i the wp_options, wp_posts, etc? where?

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

    (@tobiasbg)

    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

    Thread Starter wpmhweb

    (@wppit)

    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,

    Plugin Author TobiasBg

    (@tobiasbg)

    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

    Thread Starter wpmhweb

    (@wppit)

    Thanks,

    Plugin Author TobiasBg

    (@tobiasbg)

    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!

    Thread Starter wpmhweb

    (@wppit)

    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,

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

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

    Regards,
    Tobias

    Thread Starter wpmhweb

    (@wppit)

    @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 2 years, 4 months ago by wpmhweb.
    • This reply was modified 2 years, 4 months ago by wpmhweb.
    • This reply was modified 2 years, 4 months ago by wpmhweb.
    • This reply was modified 2 years, 4 months ago by wpmhweb.
    • This reply was modified 2 years, 4 months ago by wpmhweb.
    • This reply was modified 2 years, 4 months ago by wpmhweb.
    • This reply was modified 2 years, 4 months ago by wpmhweb.
    Plugin Author TobiasBg

    (@tobiasbg)

    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

    Thread Starter wpmhweb

    (@wppit)

    @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 2 years, 4 months ago by wpmhweb.
    Plugin Author TobiasBg

    (@tobiasbg)

    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

    Thread Starter wpmhweb

    (@wppit)

    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.

    Plugin Author TobiasBg

    (@tobiasbg)

    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

    Thread Starter wpmhweb

    (@wppit)

    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,

    Plugin Author TobiasBg

    (@tobiasbg)

    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

Viewing 15 replies - 1 through 15 (of 19 total)
  • The topic ‘What db table does TablePress saves the tables’ is closed to new replies.