SQL Script for deleting orphaned Yoast meta data. (Update table prefix!)

yoast-db-cleanup.sql

/**
 * yoast-db-cleanup.sql
 */

/*
Options
 */
DELETE FROM prefix_options WHERE option_name = 'wpseo';
DELETE FROM prefix_options WHERE option_name LIKE 'wpseo_%';
DELETE FROM prefix_options WHERE option_name LIKE '_transient_timeout_wpseo_%';
DELETE FROM prefix_options WHERE option_name LIKE '_transient_wpseo_%';

/*
Post Meta
 */
DELETE FROM prefix_postmeta WHERE meta_key = '_yoast_wpseo_canonical';
DELETE FROM prefix_postmeta WHERE meta_key = '_yoast_wpseo_content_score';
DELETE FROM prefix_postmeta WHERE meta_key = '_yoast_wpseo_focuskw';
DELETE FROM prefix_postmeta WHERE meta_key = '_yoast_wpseo_linkdex';
DELETE FROM prefix_postmeta WHERE meta_key = '_yoast_wpseo_meta-robots-noindex';
DELETE FROM prefix_postmeta WHERE meta_key = '_yoast_wpseo_metadesc';
DELETE FROM prefix_postmeta WHERE meta_key = '_yoast_wpseo_primary_category';
DELETE FROM prefix_postmeta WHERE meta_key = '_yoast_wpseo_redirect';
DELETE FROM prefix_postmeta WHERE meta_key = '_yoast_wpseo_title';
DELETE FROM prefix_postmeta WHERE meta_key LIKE '_yoast_wpseo_primary_%';

/*
User Meta
 */
DELETE FROM prefix_usermeta WHERE meta_key = 'prefix_yoast_notifications';
DELETE FROM prefix_usermeta WHERE meta_key LIKE 'wpseo%';
DELETE FROM prefix_usermeta WHERE meta_key LIKE '_yoast_wpseo%';