WordPress Website Database Error

The Easiest Way to Reset Your WordPress Website

Have you ever wanted to just start over, with a clean slate? Maybe you’re trying out a new theme on a staging site. Or perhaps you’re testing the compatibility of a few plugins in your own sandbox. This is when you might want to reset your WordPress database.

In these cases you’re most likely importing or creating sample data to test with, and once you’re done testing you’ll probably want to get rid of it. You could just delete the data bit by bit manually, but that takes forever. Or you could use the Advanced WordPress Reset plugin to put your site back to the way it was when you started in just a few seconds.

How to Reset Your WordPress Database

The easiest way we’ve found to quickly reset the WordPress database is with the free Advanced WordPress Reset plugin. This plugin cleans out the users, blog posts, store products, portfolio items or anything else you might have added to your WordPress installation along with all of the accompanying media files, comments, taxonomies, ratings, etc. It does not delete your installed themes and plugins – it will simply deactivate these (so no worries).

We highly recommend using this plugin in test environments where you constantly need to start over. We use it ourselves when doing testing for our Total WordPress theme as well as for many of the plugin reviews you see on our blog. While the plugin currently does not support multisite, it does a fantastic job on single installations and really speeds up the testing and re-testing process.

Now that you know what the Advanced WordPress Reset plugin does, here’s how you can install and use it to reset your site.

Step 1: Install The Advanced WordPress Reset Plugin

First, log into your WordPress installation and navigate to Plugins > Add New. Search for “database reset” and look for the Advanced WordPress Reset (it should be the first result). Click the button to Install and then Activate the plugin.

Step 2: Reset Your WordPress Database

Once active the plugin will add an Advanced WP Reset option under Tools. This is where you will be able to reset your site.

Important Note: Remember that this plugin resets your entire website, meaning all of your users (except for the admin), posts, pages, staff, portfolio and everything else will be deleted – aka gone forever. This is why we recommend it when you want a fresh start like in test environments. If you simply want to clean up your current WordPress installation we suggest using a plugin such as the Advanced Database Cleaner (from the same plugin developer).

Simply type in the word “reset” to confirm that you really do want to reset your website, then click the big blue Reset database button.

Step 3: Checkout Your Clean Installation

After confirming your reset you should see a note that it was successful (yay!). Now if you have a look around your website you’ll notice that it’s like a brand new installation.

If you click on Posts you’ll see that your website has gone back to the original WordPress “Hello World!” default post, complete with sample comment. And if you check under Pages default WordPress “Sample Page” should be back too.

Your site will have also reverted to the current default WordPress theme. But don’t worry – all of your themes and plugins should still be installed. The Advanced WordPress Reset simply deactivates them (see the snapshot above – all of our plugins are still there).

Before & After

And just to give you a look, here are our test before and after pictures.

This was our test site before (complete with sample posts, taxonomies, events, menus and more).

And this is the after result. You’ll see that the Mesa theme we were using is now deactivated and our site is instead using the default 2017 WordPress theme.

Wrapping Up

There you have it! A complete guide to resetting your WordPress installation with the Advanced WordPress Reset plugin. It really does speed up testing if your a web designer or developer. Just be sure you’re using it on a single WordPress installation and remember that it will delete all your content (as we mentioned before – this is best for test environments, for live sites where you want to keep your content the Advanced Database Cleaner plugin is a much better choice) .

Do you have another 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!


WP Database Backup


Pro Version

WP Database Backup plugin helps you to create Database Backup and Restore Database Backup easily on single click.Manual or Automated Database Backups And also store database backup on safe place- Dropbox,FTP,Email,Google drive, Amazon S3

  • Create Database Backup
    WP Database Backup plugin helps you to create Database Backup easily on single click.
  • Autobackup
    Backup automatically on a repeating schedule
  • Download backup file direct from your WordPress dashboard
  • Easy To Install(Very easy to use)
    WP Database Backup is super easy to install.
  • Simple to configure(very less configuration), less than a minute.
  • Restore Database Backup
    WP Database Backup plugin helps you to Restore Database Backup easily on single click.
  • Multiple storage destinations
  • Store database backup on safe place- Dropbox,Google drive,Amazon s3,FTP,Email
  • Reporting- Sends emailed backups and backup reports to any email addresses
  • Exclude Table
  • Database backup list pagination
  • Search backup from list(Date/ Database Size)
  • Sort backup list (Date/ Database Size)
  • Save database backup file in zip format on local server And Send database backup file to destination in zip format
  • Documentation

Few of the Key Features

  • Database Backup easily on single click.
  • Autobackup.
  • Restore Database Backup easily on single click.
  • Store database backup on safe place- Dropbox,Google drive,Amazon s3,FTP,Email.
  • Pagination.
  • Search and sort database backup feature.
  • Documentation

Get Pro ‘WP All Backup’ Plugin

  • https://wpallbackup.com
  • www.wpseeds.com

WP All Backup will backup and restore your entire site at will, complete with FTP & S3 integration

Pro Features

  • Complete Backup
  • Create Database Backup easily on single click.
  • Autobackup Backup automatically on a repeating schedule
  • Backup Listing : Pagination.
  • Manual backup
  • Multisite compatible
  • Backup entire site
  • Exclude specific folders and files
  • Downloadable log files
  • Simple one-click restore
  • Set number of backups to store
  • Automatically remove oldest backup
  • Multiple storage destinations
  • FTP integration
  • Dropbox integration
  • Google drive integration
  • Amazon s3 integration
  • Email Notification
  • Reporting- Sends emailed backups and backup reports to any email addresses
  • ZipArchive
  • Backup zip labeled with the site name(Help when backing up multiple sites).
  • Select Backup Type: Only Database,Only Files, Complete Backup
  • Inline Help
  • Search backup from list(Date/Size)
  • Sort backup list (Date/Size)
  • Easy To Install(Very easy to use)
  • Simple to configure(very less configuration).
  • PclZip
  • Clone Site
  • Move Site
  • Change Backup folder name
  • Uses zip and mysqldump for faster back ups if they are available.
  • Exclude Tables from your back ups.
  • System Check (i.e backup folder permission, execution time etc)
  • Disk space checkup(memory available).
  • Support
  • Actualiser
  • And More….

Leave a Reply

Your email address will not be published. Required fields are marked *