reset wordpress database

Do you want to reset your WordPress database to its original settings?

If you are working on a local server or a test site, then you might need to restore your database back to how it was when you first started.

In this article, we will show you how to reset your WordPress database to default settings with just a few clicks.

Reset WordPress database to fresh install

Here is a quick overview of the steps we will cover in this tutorial:

Step 1: Prepare a WordPress Backup Before Reset
Step 2: Reset Your WordPress Database to Default Settings
Step 3: Restore WordPress Database From Backup (Optional)

Ready? Let’s begin.

Step 1: Prepare a WordPress Backup Before Reset

WordPress stores all your website content in a database. This includes your posts, pages, media file data, plugin and theme settings, and more.

If you have been working on a test site on a local server or a staging site, then you sometimes may wish to reset to a fresh install to start over.

Resetting your WordPress database is the fastest way to do this. It deletes all your WordPress data without deleting any files stored on your web hosting server.

However, If you reset your WordPress database, then all the data will be gone forever. It cannot be undone.

We recommend making a complete WordPress backup before you go any further. You can also back up your WordPress database alone if you don’t want to back up your entire website.

Now, we will show you two methods to quickly back up your WordPress database before the reset. You can choose the one that works best for you.

Method 1: Make WordPress Database Backup Using Duplicator

Duplicator is the best WordPress backup plugin on the market. It allows you to easily back up your WordPress website and quickly restore it from the backup.

First, you need to install and activate the Duplicator plugin. For more details, see our step-by-step guide on how to install a WordPress plugin.

Note: There is also a free version of Duplicator that you can use. However, we recommend upgrading to the paid plan to unlock the full potential of the plugin.

Upon activation, go to the Duplicator » Packages page and click the ‘Create New’ button.

Next, you need to provide a name for your backup.

Click on the ‘Next’ button to continue.

Duplicator will now scan your WordPress website and show the scan results.

It may show some notices, like if you don’t have a WordPress security plugin installed or are using an outdated version of WordPress.

You can ignore these notices. If everything else looks good, then click on the ‘Build’ button to continue.

The plugin will back up your WordPress database and show you the download options.

Simply click on the ‘Download’ and ‘Both Files’ buttons to continue.

Duplicator will now send both the Archive and the Installer files as downloads to your computer.

Method 2: Create a Database Backup Using Advanced WP Reset

For this method, you will be using the Advanced WP Reset plugin. It is the same plugin that you will use in the next step to reset your WordPress database.

However, the downside of this backup approach is that you will have to restore your WordPress database using phpMyAdmin.

First, you need to install and activate the Advanced WP Reset plugin. For more details, see our step-by-step guide on how to install a WordPress plugin.

Upon activation, go to the Tools » Advanced WP Reset page and switch to the ‘Snapshots’ tab.

Make database backup with Snapshots tool

Provide a name for your backup, and then click the ‘Take Snapshot’ button.

The plugin will now prepare a copy of your database and store it as a backup. You will see it listed under the Available Snapshots section.

However, when you reset your WordPress database, the plugin will also delete this snapshot. You need to save it on your computer to use it later.

Click on the plus [+] icon to expand the snapshot options, and then click on the ‘Download’ button.

Your database backup will now download as an SQL file to your computer.

Step 2: Reset Your WordPress Database to Default Settings

Now, you need to install and activate the Advanced WP Reset plugin. For more details, see our step-by-step guide on how to install a WordPress plugin.

Next, go to the Tools » Advanced WP Reset page and switch to the ‘Reset’ tab.

Under the Site Reset section, the plugin will show you all the data it will reset. This includes the following:

Pages, posts, and comments
Custom database tables (created by you or a WordPress plugin installed on your site)
Users except for the current admin user
Advanced WP Reset plugin data (including snapshots and settings)

Below that, it will show you which data will not be deleted. This includes the following items:

The admin user account
Files, uploads in the media library, themes, plugins, and more. However, any plugin or theme data stored in the database will be deleted.
Basic WordPress settings, including site title, WordPress address, site address, timezone, and language options
Non-WordPress database tables. These tables don’t share the table prefix set in your WordPress database settings.

If everything looks good, just type ‘Reset’ under the Warning label and then click the ‘Reset’ button.

This will bring up another popup warning.

Simply click the ‘Reset Now’ button to continue.

The plugin will now reset your WordPress database to its default settings.

Once finished, you will see a success message.

You can now continue using your website with the default database settings.

Note: Upon reset, the plugin will recreate the default WordPress content that comes with a fresh install of WordPress. It includes a blog post titled ‘Hello World’, ‘A Sample Page’ under Pages, and a sample comment under Comments. Feel free to delete those manually.

Step 3: Restore WordPress Database From Backup (Optional)

If, for some reason, resetting your WordPress database to default settings didn’t work, then you can restore your database from the backup created in the first step.

Method 1: Restore Duplicator Database Backup

If you created your WordPress database backup using the Duplicator plugin, then here is how you will restore your website.

During the database reset, the Advanced WP Reset plugin will deactivate all other WordPress plugins installed on your site.

Go to the Plugins page in the WordPress admin area to activate the Duplicator plugin.

Once the plugin is activated, you need to visit the Duplicator » Import page.

Here, you need to upload the Archive file you downloaded in the first step.

Next, the plugin will scan your archive file and show you the package details.

If everything looks good, just click the ‘Continue’ button to begin the import.

On the next screen, you may be asked to confirm that you want to continue without a recovery point.

Since you already have the latest backup, it is safe to continue without creating a recovery point.

Scroll down to the bottom of the page.

You will see the number of posts, pages, comments, and media under the system overview. Click on the ‘Launch Installer’ button to continue.

This will launch the Duplicator installer.

Upon launch, the installer will automatically choose ‘Restore single site’ as your restoration type.

Scroll down to the Validation section.

Here, you will again see the warning about the recovery point. You need to check the box next to the ‘I have read and accept all terms and notices’ option.

Click on the ‘Next’ button to continue.

Duplicator will now show you a popup with your installer settings. Go ahead and click on the ‘OK’ button.

Duplicator will now start importing your website from the backup and restore your WordPress database.

Once finished, you will see a success message with a button to log in to the WordPress admin area.

Method 2: Restore Database Backup from SQL File

If you saved your WordPress database method using the Advanced WP Reset plugin’s Snapshots tool, then here is how you will restore the database.

First, you need to open up phpMyAdmin. It is a web-based tool that allows you to easily perform database operations using a friendly interface.

If the website you are trying to store is hosted on your web server, then log in to your WordPress hosting account control panel (cPanel).

From here, you need to find the Database section and click on the ‘phpMyAdmin’ button.

This will open phpMyAdmin in a new browser tab.

On the other hand, if you were working on a local website on your computer, then you can open phpMyAdmin or a similar tool from the software that you are using for local sites.

We recommend using Local, which does not come with phpMyAdmin. Instead, it uses Open Adminer to manage databases.

Once you are in phpMyAdmin, make sure that you have selected the database for your website.

Select all database tables in phpMyAdmin by clicking on the ‘Check all’ box at the bottom of the table list. After that, select ‘Drop’ from the ‘With selected’ dropdown menu.

This will empty your WordPress database.

You can now switch to the ‘Import’ tab at the top and click on the ‘Choose File’ button to select the SQL file you downloaded earlier.

After choosing the file, feel free to review the on-screen options. The default settings will work for most websites.

Scroll down toward the bottom of the page and click on the ‘Import’ button.

phpMyAdmin will now upload your SQL file and run it.

After that, you will see a success message.

You can now visit your website and log in to see your database restored to its previous settings.

We hope this article helped you learn how to reset your WordPress database to default settings. You may also want to check out our beginner’s guide to WordPress database management and our expert picks for the best WordPress database plugins.

If you liked this article, then please subscribe to our YouTube Channel for WordPress video tutorials. You can also find us on Twitter and Facebook.

The post How to Reset Your WordPress Database to Default Settings first appeared on WPBeginner.

Recently, one of our readers asked us, “How do I restart my WordPress site?”.

This isn’t something that most users will need to do, but knowing how to reset WordPress can be very helpful in some situations.

In this tutorial, we’ll show you how to restart or reset your WordPress site, the fast way.

Why Restart a WordPress Site?

Restarting or resetting WordPress is a process where you restore WordPress to the default settings. Think of it as a similar process to restoring your phone to the default “factory settings”.

It will delete all your apps and customizations, so you can start over fresh.

There are several situations where you might want to restart or reset a WordPress site:

1. You’re using a demo site on your own computer. If you’ve installed WordPress on localhost, then you might want to reset after you’ve built a site and moved it from localhost to a live server. If you’re a developer and constantly test themes & plugins on your local install, then it can help to reset it every quarter to start fresh.

2. You’ve been working on a new site and want to start over. Maybe you’ve been busy creating a blog or website, but you are not happy with the customizations. Instead of undoing everything, you can simply reset WordPress and quickly start over with a new design.

3. You’re going to rework a client’s website. If they want something very different from what’s already there, then you might need to reset WordPress on staging server to start from scratch.

4. You’re learning about WordPress, hands-on. Maybe you’ve had a go at developing your own plugins or themes, or you’ve been experimenting with a starter theme. You might want to start again with a fresh installation of WordPress.

How to Restart and Reset a WordPress Site

Restarting your WordPress site might sound difficult, but it’s really not.

We’re going to walk you through the entire reset process, step by step.

Before you begin, it’s important to create a full backup of your site using a WordPress backup plugin. This is important in case you want to restore your site from the backup after restarting it.

Restart Your WordPress Site with WP Reset

Now you’re ready to move on and restart your WordPress site. We’re going to use the free version of the WP Reset plugin for this.

First, you’ll need to install and activate the WP Reset plugin. For more details, see our instructions on how to install a WordPress plugin.

Once the plugin is activated, you need to go to the Tools » WP Reset in your WordPress dashboard and scroll down to the Site Reset section of the page.

To reset your site, you need to type the word ‘reset’ in the confirmation field before clicking the red ‘Reset Site’ button.

WP Reset will pop up a message asking you to confirm that you want to reset the site. Click ‘Reset WordPress’ to continue.

You’ll see a ‘Resetting in progress’ message for a few seconds. Then, your site will be restarted.

Next, you’ll see the homepage of your WordPress dashboard with a success message at the top from WP Reset.

That’s it. You’ve restarted your WordPress site.

Optional WP Reset Functions When Restarting Your Site

The above method gives you everything you need in order to restart your site.

However, there are some other options in WP Reset that you might want to use too.

Taking a Snapshot of Your WordPress Site Before Restarting

You can use WP Reset to take a snapshot of your site. A snapshot is a restore point for your WordPress database. It lets you see what changes have been made since the snapshot was taken. You can use it to roll back changes if necessary.

Important: A snapshot is not a WordPress backup. You should still make backups to restore your website.

To create the snapshot, click on the Snapshots tab. Then, scroll down and click the Create Snapshot button:

You’ll be prompted to enter a name or description for the snapshot. Type in whatever you want to use, then click the ‘Create snapshot’ button.

Deleting Themes and Plugins Using WP Reset

By default, WP Reset doesn’t delete theme and plugin files. It simply deactivates them. However, you can use it to delete these files too.

First, you’ll need to go to Tools » WP Reset and click the ‘Tools’ tab. Once there, simply click on the ‘Delete Themes’ or ‘Delete Plugins’ links to jump straight to those tools.

Once you click either link, you’ll be scrolled down the page to the right tool:

You can click the ‘Delete all themes’ or ‘Delete plugins’ button to delete them.

Important: WP Reset doesn’t backup your files in any way. Deleting your themes and plugins can’t be undone.

After you click the button, you’ll be prompted to confirm. Click the Delete button on the popup to continue.

You’ll then see a message telling you how many themes or plugins have been deleted.

If you delete all themes, then you’ll need to install and activate a theme manually. Your site won’t work without one. If you go to Appearance » Themes, then you’ll see a screen like this:

Go ahead and click the ‘Add New’ button and choose or upload a theme of your choice. If you need help, check out how to install a WordPress theme.

Restoring Your Data After Restarting Your WordPress Site

After restarting your WordPress site, any posts and pages you had will be gone. Instead, you’ll see the default pages and the ‘Hello, world’ post:

To restore your old data, you will need to reinstall and activate the backup plugin that you used to create your backup.

You can then follow its instructions to restore your site from the backup.

Viewing Your Restored Content

Once you’ve restored your site from backup, your content should be back on your site.

You’ll find all your posts under Posts » All Posts. They’ll have the correct time stamps, categories, tags, and comments.

We hope this tutorial helped you learn how to reset a WordPress site the fast way. You might also like our ultimate guide to speeding up WordPress and our list of must have WordPress plugins for all sites.

If you liked this article, then please subscribe to our YouTube Channel for WordPress video tutorials. You can also find us on Twitter and Facebook.

The post How to Restart a WordPress Site – Reset WordPress (The Fast Way) appeared first on WPBeginner.