Title: Migrating SEO data
Last modified: December 29, 2023

---

# Migrating SEO data

 *  Resolved [lastnoob](https://wordpress.org/support/users/lastnoob/)
 * (@lastnoob)
 * [2 years, 5 months ago](https://wordpress.org/support/topic/migrating-seo-data/)
 * 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 2 years, 5 months ago by [lastnoob](https://wordpress.org/support/users/lastnoob/).
    -  This topic was modified 2 years, 5 months ago by [lastnoob](https://wordpress.org/support/users/lastnoob/).
    -  This topic was modified 2 years, 5 months ago by [lastnoob](https://wordpress.org/support/users/lastnoob/).

Viewing 1 replies (of 1 total)

 *  [Rohan Sadanandan](https://wordpress.org/support/users/rohans123/)
 * (@rohans123)
 * [2 years, 5 months ago](https://wordpress.org/support/topic/migrating-seo-data/#post-17307238)
 * Hi [@lastnoob](https://wordpress.org/support/users/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](https://wordpress.org/plugins/wp-all-import/).
   They have [a tutorial on their site](http://www.wpallimport.com/documentation/plugins-themes/yoast-wordpress-seo/)
   on importing data into the Yoast SEO plugin.

Viewing 1 replies (of 1 total)

The topic ‘Migrating SEO data’ is closed to new replies.

 * ![](https://ps.w.org/wordpress-seo/assets/icon-256x256.gif?rev=3419908)
 * [Yoast SEO - Advanced SEO with real-time guidance and built-in AI](https://wordpress.org/plugins/wordpress-seo/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wordpress-seo/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wordpress-seo/)
 * [Active Topics](https://wordpress.org/support/plugin/wordpress-seo/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wordpress-seo/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wordpress-seo/reviews/)

## Tags

 * [export](https://wordpress.org/support/topic-tag/export/)
 * [Import](https://wordpress.org/support/topic-tag/import/)
 * [migrate](https://wordpress.org/support/topic-tag/migrate/)

 * 1 reply
 * 2 participants
 * Last reply from: [Rohan Sadanandan](https://wordpress.org/support/users/rohans123/)
 * Last activity: [2 years, 5 months ago](https://wordpress.org/support/topic/migrating-seo-data/#post-17307238)
 * Status: resolved