I’m managing a small directory website and I have set some generic titles and descriptions for my pages with Yoast SEO Plugin.
I’d like to duplicate them to every entry/page directly via the MySQL database. However, I cannot find it in the DB.
I didn’t find it in wp_postmeta
, wp_posts
or wp_yoast_seo_meta
.
That’s why I ask: where does Yoast (v. 7.8) store the SEO informations that a user set?
4
Answers
So after some time, I figured out that the best way to find out where this data where stored was to dump the DB and look in that dump:
What you'll find is an row called
wpseo_taxonomy_meta
in tablewp_options
which contains every taxonomy SEO texts. It is saved as a PHP serialised value.Be careful though that this is just for the SEO texts of the Taxonomies (e.g. Location, Feature, Category...). It doesn't apply to the SEO descriptions and titles of the posts themselves (these are stored in
wp_postmeta
with at least one row per post).just use this code, you’ll get an array of all settings that Yeast SEO show under “Search Appearance” page. Including title, descriptions and all other settings.
Update your required field and save using the update_option() function of WordPress.
Yoast SEO Save Description and Keywords in wp_yoast_indexable Table. Where you can see column name description and keywords
You can use this (for categories):
It should work. Also, you should check the wp_yoast_indexable table for correct recordings.