Copying Database Loses Yoast Settings…but kinda doesn’t

  • Resolved skyhawkpictures

    (@skyhawkmedia)


    4 years, 8 months ago

    Hi there,
    I work on a dev version of my site and upload it to prod when ready.
    The upload to prod involves copying all my database table data from dev to prod.

    After doing this, I can see that all the wp_option data has been successfully transferred (the Yoast data has too …wpseo% options).

    However, none of the data (that is definitely, plainly there in the DB) appears when I load up the Yoast dashboard. The organisation name, the social accounts, the opengraph image…all blank.

    Is there something I need to do to tell the front-end that the data has been man-handled into the db?

    Thanks
    Steve

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Support devnihil

    (@devnihil)

    No additional step in the front end should be required to read the information from the database. If you clear your cache (server, plugin/theme, browser, or CDN such as Cloudflare) does this resolve the issue? If you are not sure how to clear your server cache you should speak with your host provider.

    Thread Starter skyhawkpictures

    (@skyhawkmedia)

    Hi thanks for the reply.

    Alas, no. I don’t really have a server-side cache. I do use Cloudflare and have cleared that, but that doesn’t make any difference.

    I have a contingency site that runs on my own servers here in-house and a production site held on web-hosting. Whenever I promote my site from dev, both the contingency site and production site exhibit the same symptoms – seemingly no structured data (yet it’s there in the database).

    Thanks
    S.

    Sa?a

    (@stodorovic)

    It seems that serialized strings are broken into wp_options table. It’s possible if you use SQL query (eg. UPDATE …) to replace dev domain with prod domain.

    I use (and recommend) this tool – https://interconnectit.com/products/search-and-replace-for-wordpress-databases/. You can use it as standalone script (don’t need to install it into WP). There are other solutions which are safe related to serialized strings or objects.

    Thread Starter skyhawkpictures

    (@skyhawkmedia)

    Thanks but that’s not the issue.

    1. all occurrences of dev domain are updated to prod domain as part of my promotion to prod process (in all tables, not just options).

    2. any particular piece of data in the options table (domain name or anything else) should not prevent it from loading into the front-end.

    Cheers,
    S.

    Plugin Support amboutwe

    (@amboutwe)

    Based on the information you provided, we expect this to be a bug. We’re actively using the bug tracking on our GitHub repository so your best next step would be to create a new issue for our developers here. You will need an account to create a new issue. Don’t forget to include the URL to this conversation in your bug report.

    If you have not submitted an issue previously, this guide will help you submit a complete report which may result in a faster resolution.

    Plugin Support Jerlyn

    (@jerparx)

    Closed. No other concerns.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Copying Database Loses Yoast Settings…but kinda doesn’t’ is closed to new replies.