• Resolved lorysapo

    (@lorysapo)


    Hi, I have a problem with custom tabs and I really hope you can help me.
    Before September I had several custom tabs realized with your plugin. Unfortunately, accidentally, the plugin has been deleted. Now I installed the plugin again, but tabs aren’t visible anymore (obviously…)
    I have one backup of September ’21, but if I restore the backup, I’m afraid I will lose changes done in the last months.
    Is there a way to restore just a database in order to have my tabs’ contents back?

    I’m not very familiar with database, but I can have access to phpmyadmin.
    Thanks in advance

Viewing 5 replies - 1 through 5 (of 5 total)
  • Hi @lorysapo,

    Unfortunately, if you’ve deleted the plugin completely, the plugin will clean up the database to avoid leaving any unwanted data. There’s not an easy way to undo that beyond restoring a backup.

    The tabs are stored in the wp_postmeta table. yikes_woo_products_tabs is the key, and each will be associated with a certain Post ID. You could take the backup, set it up on another environment, and create a script to pull out the tab meta assignments into a spreadsheet. Then you could create another script to upload that information to your new site. We don’t have any sort of automated tool for this, but extending WP CLI is probably your best bet here.

    You might also be able to find some sort of plugin that allows you to copy just meta, or just certain types of meta between sites. I’ve never used a tool like that, but it strikes me as the sort of thing that would be on the plugin marketplace.

    I’m sorry that this likely isn’t the answer you’re looking for. Missing and corrupted data is often very tricky to resolve.

    Let me know if that helps,
    Jon

    Thread Starter lorysapo

    (@lorysapo)

    Many thanks for your quick reply.
    Do you think I can replace the new “yikes_woo_products_tabs” with the old one?
    This table contents only information about product, isn’t it?

    As I told you I’m not so familiar with sql, but I was thinking to rename the actual “yikes_woo_products_tabs” and then import the old one. Can it work?

    Thanks again.
    Lory

    Hi @lorysapo,

    Unfortunately it’s not a table, it’s a meta key. There will be thousands of rows in the wp_postmeta table, but some of them will have that key. You could delete all of the items with that key, but you’d still have to find a way to import the values from the previous database with only that key.

    Jon

    Thread Starter lorysapo

    (@lorysapo)

    Hi Jon,
    ah, I’ve understood now.
    the table is wp_postmeta table and inside this table and yikes_woo_products_tabs is a key… actually you wrote it in the first message. Sorry!
    So now the question is: what if I will replace “wp_postmeta” with the old one?

    Thanks
    Lory

    Hi @lorysapo,

    No problem! wp_postmeta stores all the “meta” about your different posts, and is basically) where anything other than title and body content lives. If you replaced the whole table, that would be pretty similar to restoring a backup, as anything newer than the backup would still be missing.

    Jon

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Lost Tabs’ is closed to new replies.