Have you ever thought about starting over, starting from scratch? Maybe you’re trying out a new theme on a staging site. Alternatively, you might be testing some plugins for compatibility in your own sandbox. This is when you might want to reset your WordPress database.
In these cases, you will most likely import or create sample data to test, and you may want to get rid of it once you’re done testing. You can manually delete data bit by bit, but it will take a long time.or you can use Premium WordPress Reset Plugin Restore your website to the way it started in seconds.
How to reset your WordPress database
We’ve found that the easiest way to quickly reset your WordPress database is to use a free Premium WordPress Reset Plugin. This plugin clears users, blog posts, store products, portfolio items, or anything else you may have added to your WordPress installation along with all accompanying media files, comments, categories, ratings, etc. It doesn’t remove themes and plugins you installed – it just deactivates those (so no worries).
We strongly recommend using this plugin in test environments where you often need to start over. We use it ourselves when testing our Total WordPress theme and the many plugin reviews you see on our blog. While the plugin doesn’t currently support multisite, it does a great job with a single install and does speed up the testing and retesting process.
Now that you know what an advanced WordPress reset plugin does, here’s how you can install and use it to reset your website.
Step 1: Install Premium WordPress Reset Plugin
First, log into your WordPress installation and navigate to Plugins > Add New. Search for “database reset” and look for Advanced WordPress Reset (it should be the first result).Click the button Install then enable plugin.
Step 2: Reset your WordPress database
Once activated, the plugin will add a Advanced WP reset Options under Tools. You can reset your website here.
Important note: Remember that this plugin resets your entire website, which means all your users (except admins), posts, pages, employees, portfolios and everything else will be deleted – aka gone forever . That’s why we recommend it when you want to start over in a test environment.If you just want to clean up your current WordPress installation, we recommend using a plugin such as Advanced Database Cleaner (from the same plugin developer).
Just enter the word “reset” to confirm that you really want to reset your site, then click the blue reset database button.
Step 3: Check your fresh install
After confirming your reset, you should see a message stating that it was successful (yay!). Now, if you take a look at your website, you’ll see that it’s like a fresh install.
if you click post You’ll see that your site is back to the original WordPress “Hello World!” default post, with a sample comment.if you check page The default WordPress “example page” should also be back.
Your website will also revert to the current default WordPress theme. But don’t worry – all your themes and plugins should still be installed. An advanced WordPress reset just deactivates them (see snapshot above – all our plugins are still there).
before and after
Just to give you a look, here are before and after photos of our test.
This is our test site forward (Contains example posts, taxonomies, events, menus, etc.).
This is Rear result. You’ll see that the Mesa theme we’re using is now retired, and our site is using the default 2017 WordPress theme.
you have it! A complete guide to resetting your WordPress installation using the Advanced WordPress Reset plugin. It really speeds up testing if you are a web designer or developer.Just make sure you’re using it on a single WordPress install, and remember that it deletes all your content (as we mentioned before – this is best for test environments, for live sites where you want to keep content Advanced Database Cleaner Plugins are a better option).
Do you have any other way to reset WordPress? Or any questions about using How to reset your WordPress database? Or about using the Advanced WordPress Reset plugin? Let us know in the comments below!