Database issue after using WP Staging

  • Resolved glen4cindy

    (@glen4cindy)


    6 years, 1 month ago

    I followed the YouTube video to create a staging website and then decided that I wanted to delete this and begin again.

    I didn’t actually follow through with it because I’m afraid there is an issue with the database now.

    Before I even installed the plugin, there was a single database: Database: fwcmetro_wrdp1

    That database is sill there, but now it’s full of entries that begin “wpstag0” that were never there to begin with.

    Now I do not know what to do. I’m fearful if I delete the staging site my production site will crash. I made several changes to the site after working on the staging site.

    How can this issue be fixed now? Thanks in advance.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Rene Hermenau

    (@renehermi)

    6 years, 1 month ago

    Hello Glen,

    I’ve already replied to your mail but will answer here as well. This answer can be useful for other people, too.

    WP Staging does not change any of your live tables. It creates new tables beginning with wpstg0_ and does not modify your production tables at all. So they still exist if you did not change anything manually in the database.

    How do you see your database tables?

    Do you use PHPMyAdmin? This tool shows only a portion of your tables at a glance and you need to click on the second page to see the rest of the existing tables. So could this be the issue you have?

    When you delete a staging site WP Staging will show you a preview of the tables that are going to be deleted. There should be selected tables beginning with wpstg0_ only.

    Tables beginning with fwcmetro_wrdp1 should not be in that delete preview.

    If that’s the case, all is good and you can proceed with deleting the staging site tables. It will not delete any of your production site tables.

    Please let me know if you have any other questions or need more information.

    Thread Starter glen4cindy

    (@glen4cindy)

    6 years, 1 month ago

    Sorry to ask in more than one place, I’m just a bit worried.

    Yes, I was looking in PHPMyAdmin.

    That’s where I went recently when I was moving hosting companies to backup and restore the database.

    I was not aware that only a portion of the tables was visible there. With the kind of luck I have, I would have hit DELETE and the site would have vaporized!

    Thanks for your quick response.

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

The topic ‘Database issue after using WP Staging’ is closed to new replies.