If you want to migrate from the Yoast SEO plugin to alternative plugins, it is also worth making sure that any Yoast SEO plugin data is deleted from the site’s database.
The custom database tables that the Yoast SEO plugin creates;
wp_yoast_indexable
wp_yoast_indexable_hierarchy
wp_yoast_migrations
wp_yoast_primary_term
wp_yoast_prominent_words
(note: only available in the Yoast SEO Premium plugin)
wp_yoast_seo_links
The option names that the Yoast SEO plugin uses;
_transient_wpseo_unindexed_post_link_count
_transient_timeout_wpseo_unindexed_post_link_count
_transient_wpseo_unindexed_term_link_count
_transient_timeout_wpseo_unindexed_term_link_count
_transient_wpseo_total_unindexed_general_items
_transient_timeout_wpseo_total_unindexed_general_items
_transient_wpseo_total_unindexed_post_type_archives
_transient_timeout_wpseo_total_unindexed_post_type_archives
_transient_yoast_i18n_wordpress-seo_promo_hide
wpseo_social
wpseo_titles
wpseo
yoast_migrations_free
Wpseo_taxonomy_meta
If you migrated to an alternative SEO plugin, such as Rank Math SEO, it could clean Yoast SEO data after migrating.
But if you used a different SEO plugin that does not include Yoast SEO data cleanup. In that case, the custom database tables can be deleted using a plugin such as WP-Optimize or phpMyAdmin on your hosting provider.
To find and delete the Yoast SEO plugin database tables using the WP-Optimize plugin, you can search for the Yoast keyword in the database tables screen and remove the related database tables.
Keeping excess bloat out of the site’s database will help make database cleanup and optimization easier to do in the future.
Did You Know! You can manage the Yoast SEO plugin settings across multiple WordPress settings directly from inside MainWP using the WordPress SEO Extension.