Yoast adding “view” to Database?

  • Resolved eddt

    (@eddt)


    5 years, 2 months ago

    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

    (@amboutwe)

    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

    (@eddt)

    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.