export/import tabs content from phpmyadmin

  • Resolved apagoa

    (@apagoa)


    5 years, 10 months ago

    Hi, so recently we updated wordpress to 5.0.3 and woocommerce with all plugins that we have to their recent version but it seemes that somehow the content of the tabs disappeared. I tried to search in phpmyadmin to see if the information was still somewhere in the database but it didn’t show any results. But I have a staging website that I created before doing the updates and did the same research in the database and there are the content.

    screenshot of search in phpmyadmin: https://prnt.sc/mdh62x

    How can I export the tabs information that is in the stating website’s database and imported to my active website’s database?

    Thank you, I hope you can help me

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Contributor yikesitskevin

    (@yikesitskevin)

    Hi @apagoa,

    Can you confirm the plugin is still active on your site? I’ve seen tabs disappear from the front end but I’ve never seen tabs disappear from the database. The only way this would happen is if the plugin was completely deleted from your site.

    There are a few ways to migrate tabs. Because you’re on the same site and your product IDs should all be the same, the easiest way is a direct MySQL import/export. Are you at all familiar with importing/exporting MySQL data?

    The key you’re looking for is the yikes_woo_products_tabs in the table wp_postmeta. (i.e. SELECT * FROM wp_postmeta WHERE meta_key = 'yikes_woo_products_tabs'). If you run that on your staging environment you should see all of your tabs. You can export this file and import it into your production database.

    Let me know if you need more detailed instructions.

    Thank you,
    Kevin.

    Thread Starter apagoa

    (@apagoa)

    Hi, thank you for your soon response. It worked but not completely, I mean, I did import to the database the content from the tabs to my active website but not all the products are showing the tabs in the frontend, but the information is in the backend.

    What do you think I should do?

    Plugin Contributor yikesitskevin

    (@yikesitskevin)

    Hi @apagoa,

    Did you perhaps run any search and replace functions on the database before/after you imported the tabs? If the content of the tab was changed at all, they wouldn’t be imported properly.

    You should also make sure that the staging website and the production website are using the same encoding type.

    Thread Starter apagoa

    (@apagoa)

    No, I didn’t make any changes, I just export and import.
    I think they are the same encoding type because they are in the same hosting, in the same account, and I didn’t change anything when merge the staging website with the active website.

    Plugin Contributor yikesitskevin

    (@yikesitskevin)

    Hmm. Okay. Do you see 140 rows in your production site’s DB now?

    Thread Starter apagoa

    (@apagoa)

    yes.

    Plugin Contributor yikesitskevin

    (@yikesitskevin)

    Sounds like the data got corrupted along the way. I’ve seen this happen before; serialized arrays are a bit of a pain. Could you email us at plugins [at] yikesinc [dot] com and reference this ticket? I’d like to see and test the MySQL file you’re trying to upload.

    Thank you & apologies for the hassle.

    All the best,
    Kevin.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘export/import tabs content from phpmyadmin’ is closed to new replies.