Restore Tables on migrated website

  • Resolved oggordon

    (@oggordon)


    6 years, 3 months ago

    Hey guys,
    first of, thanks a lot for this plugin. Unfortunately I was dumb enough to migrate my website without prior exporting my tables. This is what I found:

    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.

    Is there a way to get those tables to my new migrated website?

    Thanks in advance and greetings from Germany.

    Van

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    How exactly did you migrate your date to the new site? What method did you use?
    Do you still have access to the old site?

    Regards,
    Tobias

    Thread Starter oggordon

    (@oggordon)

    Hey Tobias,

    thanks for your quick response. Unfortunately I don’t have access to the old website anymore. I exported the database und imported it into the new website. There I was able to find my tables in “wp_posts”. I changed the database name though, is there a way to tell the plugin that is not “wp_posts”, but “xyz_posts”? Or any way to export them from the database?

    Regards,
    Van

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    TablePress does care if the name is “wp_posts” or “xyx_posts”. It only cares that there are rows in that database table with value of “tablepress_table” in the “post_type” column. In addition, TablePress needs the “tablepress_tables” row in the “wp_options” database table. This holds the connection between the table IDs in the post IDs from the “wp_posts” database tables.
    So, did you also migrate the “wp_options” database table?

    Regards,
    Tobias

    Thread Starter oggordon

    (@oggordon)

    Hi,

    I did not migrate the wp_options entries from the old one, however, I cannot find any tablepress entries in the old wp_options section?

    Regards,
    Van

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    if you didn’t migrate the wp_options table, you basically lost the connection between table ID and post ID.

    If the other rows are in your wp_posts table however, we can at least restore the data. If possible, I’d like to take a direct look at this on your site. Could you therefore please get in touch via email (the address is in the main plugin file “tablepress.php”)? That way, I can investigate this directly. Thanks!

    Regards,
    Tobias

    Thread Starter oggordon

    (@oggordon)

    Thanks Tobias, I contacted you via email :).

    Van

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    thanks! I was able to take a look and installed “TablePress Debug Extension”. This gives you access to the raw table data (via the “TP Tables” menu on the left), and adds a “Debug” tab in TablePress. Using this, I re-added the connection between table IDs and WordPress post IDs.

    Thus, you should now see all your tables again in TablePress. However, they will most likely have different table IDs than on the old site. You should now check what ID you used for each table in the Shortcodes on the pages and change the ID to that again, on each table’s “Edit” screen.

    Regards,
    Tobias

    Thread Starter oggordon

    (@oggordon)

    Tobias!

    I just checked and changed all the table ids to the correct one. I am so thankful for your support. You can’t imagine how stressful this was for me! Thank you so much, you are truly a hero!

    Regards
    Van

    Plugin Author Tobias B?thge

    (@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!

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Restore Tables on migrated website’ is closed to new replies.