Beginner's Guide for WordPress - Start your WordPress Blog in minutes.
Choosing the Best
WordPress Hosting
How to Easily
Install WordPress
Recommended
WordPress Plugins
View all Guides

How to Reset Your WordPress Database to Default Settings

Last updated on by
Follow WPBeginner on YouTube
How to Reset Your WordPress Database to Default Settings

Have you ever found a need to reset your WordPress database to default settings? If you have WordPress on a local server or online for testing purposes, you probably found yourself thinking of a way to reinitialize your WordPress database back to its default settings. A lot of folks simply reinstall WordPress, but there is an easier solution.

Let us introduce you to the plugin WordPress Database Reset. Once you install and activate this plugin, a new option will be added under the Tools section (Tools » Database Reset ).

WordPress Database Reset

As you can see in the image above, you can either choose to reset a specific database table, or the entire database to default settings. Once you select the tables you want to reset, you are required to type a randomly generated value into the text box. This is to confirm that you really want to do this. Once you hit the blue Reset Database button, its done.

If you want to reactivate current plugins after the reset, you can select the checkbox. Otherwise uncheck it. When you reset the database, all users will be deleted except for the first user. For example, if your first user was admin, then admin will be created. If the first user was ‘syed’, then syed will be recreated.

Note: This should only be used on test/dev installs. Not really meant for live sites!

Download WordPress Database Reset


Editorial Staff at WPBeginner is a team of WordPress lovers led by Syed Balkhi. Page maintained by Syed Balkhi.

WPBeginner's Video Icon
Our HD-Quality tutorial videos for WordPress Beginners will teach you how to use WordPress to create and manage your own website in about an hour. Get started now »
  • Joe

    If this works you’re a lifesaver! Thanks.

  • Joe

    Is there a plugin/way to delete all content on a site but keep themes and plugins intact?

    Thanks.

    • http://www.wpbeginner.com/ WPBeginner Support

      You can go to phpmyAdmin and empty your database tables. Keep a backup in case you want to revert back.

  • Luke

    Thanks a lot. I was doing my head in over my messed up site. Time to start again!
    Big help

  • stacy

    Any chance this can be run from a cron job so it’s automated? I’m trying to setup a demo site and would like the content to be reset once an hour.

    On that note, any ideas on how to get the wordpress site to also delete any new images that were uploaded during that time?

    Thanks for your help!

  • Joseph

    Hi, really cool post but I do have a question…will this affect my themes? I have some premium themes i don’t want to lose.

    • http://www.wpbeginner.com Editorial Staff

      Yes it will.

  • http://www.efeffefe.com/ jim

    AMAZING, thank you so much, solved my problem when i pretty much ruined my wp.

  • Zaadu

    Thanks for this! All the times before I used to make changes to the db and make anew install of wordpress…No more from now on

  • http://www.namase.com/ namaserajesh

    Useful plugin for me, I’m using WordPress on localhost so It’ll help me to reset database to default settings.