Title: Yoast adding “view” to Database?
Last modified: January 22, 2020

---

# Yoast adding “view” to Database?

 *  Resolved [eddt](https://wordpress.org/support/users/eddt/)
 * (@eddt)
 * [6 years, 5 months ago](https://wordpress.org/support/topic/yoast-adding-view-to-database/)
 * When trying to backup/duplicate my site DB using phpMyAdmin, I discovered that
   I now have a “view” added to my WordPress DB, in addition to all of the “tables”
   that are supposed to be there.
 * This “view” is called “SEO_DATA”, and has a bunch of values from all of the Yoast
   tables in my DB.
 * But there’s something wrong with the view, because it causes the backup/duplication
   I was attempting in phpMyAdmin to FAIL – the “SEO_DATA” “view” is invalid or 
   somesuch.
 * Can I just delete it? What feature/function of Yoast caused it to be created 
   in the first place?

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Plugin Support [amboutwe](https://wordpress.org/support/users/amboutwe/)
 * (@amboutwe)
 * [6 years, 4 months ago](https://wordpress.org/support/topic/yoast-adding-view-to-database/#post-12374211)
 * I’ve checked the database of a handful of local demo sites and I haven’t seen‘
   SEO_DATA’. Nor do I see anything in our code that references `SEO_DATA`. Have
   you ever used another plugin or theme that includes SEO or integrates with Yoast?
 * It might be worth reaching out the the plugin your using to create the backup
   as they may have seen it before and have an idea which plugin/theme creates it.
 * Alternatively, you could exclude it from the backup. Restoring the backup to 
   a separate staging or test environment would allow you to see if the data impacts
   any of your day-to-day use. If it doesn’t impact anything in the staging site,
   it would likely be safe removing it all together.
 *  Thread Starter [eddt](https://wordpress.org/support/users/eddt/)
 * (@eddt)
 * [6 years, 4 months ago](https://wordpress.org/support/topic/yoast-adding-view-to-database/#post-12374579)
 * Thanks for the feedback. I was able to get the DB to replicate correctly via 
   PhpMyAdmin by tweaking some settings when exporting and importing. I’ve speculated
   that the “view” created in question might be from the ACF/Yoast tool but I’m 
   not sure.
 * In answer to your suggestion, the DB without the “view” did seem to work just
   fine, and didn’t seem to cause errors on the staging site, so it probably can
   be removed. I’d just assumed that because it was populated with Yoast data, it
   was a Yoast view.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Yoast adding “view” to Database?’ 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/)

 * 2 replies
 * 2 participants
 * Last reply from: [eddt](https://wordpress.org/support/users/eddt/)
 * Last activity: [6 years, 4 months ago](https://wordpress.org/support/topic/yoast-adding-view-to-database/#post-12374579)
 * Status: resolved