Old website data in wp_yoast_indexable

  • Resolved bcw00

    (@bcwint00)


    3 years, 9 months ago

    Last year I moved hosts from Cloudways to Kinsta but noticed that my old URL path is still located in multiple entries in the wp_yoast_indexable table. Example below.

    {"width":640,"height":640,"url":"http:\/\/<strong>wordpress-xxxxxxxx.cloudwaysapps</strong>.com\/wp-content\/uploads\/2019\/05\/pp.jpg","path":"\/www\/<strong>xxxxx_kinsta-123</strong>\/public\/wp-content\/uploads\/2019\/05\/pp.jpg","size":"full","id":9,"alt":"","pixels":409600,"type":"image\/jpeg"}

    I am planning once again on moving as Kinsta is forcing all customers to eventually use Cloudflare by default. However I plan to manually move the database as I’m setting it up on a server that does not offer migration support.

    1) Why is the site path being referenced like this?
    2) What can I do to prepare the table entries to reflect the path of the new server when I move? Is there an easy way to clear this and have it rebuild while not losing custom meta entries for titles, descriptions and what not?

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support Md Mazedul Islam Khan

    (@mazedulislamkhan)

    1) Why is the site path being referenced like this?\
    By default, Yoast SEO stores certain data to the {prefix}yoast_indexable table. So, when moving the database from one place to another without resetting the Indexables tables and migrations, those data remain in the database.

    2) What can I do to prepare the table entries to reflect the path of the new server when I move? Is there an easy way to clear this and have it rebuild while not losing custom meta entries for titles, descriptions and what not?
    We don’t recommend you transfer the relevant tables at all when migrating the database or truncate the relevant tables before moving the database to a new place. You can find the relevant guide given below:

    • Install and activate Yoast Test Helper plugin;
    • Go to Tools → Yoast Test → Yoast SEO → Reset indexables tables & migrations options to reset it;
    • Run SEO data optimization from the SEO → Tools page.

    Once the migration is completed to the new place, you can run the SEO data optimization from the Yoast SEO → Tools page where the plugin will generate the new SEO data with the new correct path.

    Thread Starter bcw00

    (@bcwint00)

    Thank you. Will try this.

    Thread Starter bcw00

    (@bcwint00)

    Sorry to open again, When transferring, do not copy the prefix_yoast_indexable table. Rather rebuild it with the above steps. Correct?

    Are there any other Yoast tables I should not carry across?

    Plugin Support devnihil

    (@devnihil)

    @bcwint00 If the database table isn’t found when you rerun the SEO data optimization, it will recreate it.

    Thread Starter bcw00

    (@bcwint00)

    Thanks for that

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Old website data in wp_yoast_indexable’ is closed to new replies.