“staging_” tables – Apparent duplicate set of tables in production WP site

  • webdad2000

    (@webdad2000)


    1 year ago

    We’ve had a self-hosted WP site for 4 – 5 years, and originally it was hosted on Bluehost. Last year we moved to a new provider and when we recently had to do some deeper DB analysis in PHPMyAdmin, I was surprised to find that our production WP site has what appears to be a duplicate set of tables whose names are prefaced with “staging_”

    There are about 250 tables total, with about 130 or so of those having this “staging_” prefix.

    We have created a staging environment on the new provider using softalicious scripts, but I’m wondering if these “staging_” tables are disposable or are they part of the process of creating a staging site (maybe used for migrating back from staging to PROD or something like that)

    Thanks for any advice / pointers.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter webdad2000

    (@webdad2000)

    One additional update, it appears that there are tables in PROD (created after our move to a new provider – new plugin installs) that do not have “staging_” buddies. So my assumption is that these “staging_” tables were created while on Bluehost. We used Bluehost tools to create staging sites over there with mixed success, so these might have been created during one of those situations.

    threadi

    (@threadi)

    As you have already realised, it could be that these additional tables have existed for some time. They are not necessary for the operation of your live web, nor do they affect the live web. WordPress itself does not create anything like this. Such tables could be created by WordPress plugins or external maintenance tools. You would have to research which ones you use yourself in the previous or current hosting.

    However, I don’t know what relevance the question has for you? If the tables are not used, you can also delete them. Create a backup of the entire database beforehand using your host’s tools (not from within WordPress). If you have any questions about how to do this, please contact your host’s support team.

    Thread Starter webdad2000

    (@webdad2000)

    Thanks. I’ll do some testing with a fresh staging site and look to delete these extraneous tables.

    Appreciate the input.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘“staging_” tables – Apparent duplicate set of tables in production WP site’ is closed to new replies.