Migrating SEO data

  • Resolved lastnoob

    (@lastnoob)


    1 year, 2 months ago

    Hi there,

    Thanks for the amazing plugin!

    I was wondering how to migrate ALL Yoast SEO data from one site to another?

    I’m reworking a very old site that has tons of outdated DB artifacts.
    So instead of importing the whole database with all the junk in it, I only imported the posts/pages/media via the WordPress importer. That should import the post metadata.

    I also manually imported the Yoast SEO tables from the database (starting with wp_yoast :

    • wp_yoast_indexable
    • wp_yoast_indexable_hierarchy
    • wp_yoast_migrations
    • wp_yoast_primary_term
    • wp_yoast_prominent_words
    • wp_yoast_seo_links
    • wp_yoast_seo_meta

    I also migrated the options starting with wpseo from the wp_options table:

    • wpseo
    • wpseo_titles
    • wpseo_social
    • wpseo_taxonomy_meta
    • wpseo_current_version
    • wpseo_premium_version
    • wpseo-premium-redirects-base
    • wpseo-premium-redirects-export-plain
    • wpseo-premium-redirects-export-regex
    • wpseo_tracking_last_request
    • wpseo_ryte
    • wpseo_premium
    • wpseo_redirect

    Is there anything else I’d need to do?

    Thanks in advance!

    • This topic was modified 1 year, 2 months ago by lastnoob.
    • This topic was modified 1 year, 2 months ago by lastnoob.
    • This topic was modified 1 year, 2 months ago by lastnoob.
Viewing 1 replies (of 1 total)

  • Hi @lastnoob

    Thanks for using the Yoast SEO plugin.

    The SEO data you enter in Yoast SEO for your posts (i.e. focus keyphrase, SEO title, meta description, etc.) are stored in the?wp_postmeta?table of the WordPress database. The relevant meta keys are:?_yoast_wpseo_focuskw,?_yoast_wpseo_title, _yoast_wpseo_metadesc, etc.

    If you want to import the SEO data from a CSV and not the posts themselves, you may try a plugin like?WP All Import. They have?a tutorial on their site?on importing data into the Yoast SEO plugin.

Viewing 1 replies (of 1 total)
  • The topic ‘Migrating SEO data’ is closed to new replies.