how to fix The wp_yoast_indexable table when its corrupted. -

Here’s how to fix a corrupted wp_yoast_indexable table:

Method 1 – Using Yoast’s Built-in Tools:

Go to SEO → Tools in WordPress admin
Click on “Database cleanup and reset”
Select “Reset indexables tables”
Click “Reset selected items”

Method 2 – Manual Database Fix:

Access your WordPress database via phpMyAdmin
Find and drop these tables:
- wp_yoast_indexable
- wp_yoast_indexable_hierarchy
- wp_yoast_migrations
- wp_yoast_primary_term
- wp_yoast_seo_links
Deactivate Yoast SEO plugin
Reactivate Yoast SEO plugin (this will recreate the tables fresh)

Method 3 – Direct SQL Commands:

DROP TABLE IF EXISTS `wp_yoast_indexable`;

DROP TABLE IF EXISTS `wp_yoast_indexable_hierarchy`;

DROP TABLE IF EXISTS `wp_yoast_migrations`;

DROP TABLE IF EXISTS `wp_yoast_primary_term`;

DROP TABLE IF EXISTS `wp_yoast_seo_links`;

Then reactivate the plugin.

If these methods don’t work, you may need to:

Export all Yoast SEO settings
Completely uninstall Yoast
Delete remaining database tables
Reinstall Yoast fresh
Import your saved settings

Remember to always backup your database before attempting any of these fixes.

Thank you for reading! Please stay connected with me on all my social media platforms. @djmakeart

www.instagram.com/djmakeart

www.youtube.com/djmakeart

www.tiktok.com/djmakeart

www.facebook.com/djmakeart

www.x.com/djmakeart

For more updates, tips, and inspiration. Don’t forget to explore my website djmakeart.com for exclusive content and projects. Let’s create and grow together—see you there!