How to Reset Your WordPress Database to Default Settings

Do you need to reset your WordPress database to its unique settings?

In case you are engaged on a neighborhood server or a check web site, then you definately may want to revive your database again to the way it was if you first began.

On this article, we’ll present you the way to reset your WordPress database to default settings with only a few clicks.

Here’s a fast overview of the steps we’ll cowl on this tutorial:

Prepared? Let’s start.

Step 1: Put together a WordPress Backup Earlier than Reset

WordPress shops all of your web site content material in a database. This contains your posts, pages, media file knowledge, plugin and theme settings, and extra.

When you have been engaged on a check web site on a local server or a staging site, then you definately typically could want to reset to a contemporary set up to begin over.

Resetting your WordPress database is the quickest means to do that. It deletes all of your WordPress knowledge with out deleting any information saved in your hosting server.

Nonetheless, Should you reset your WordPress database, then all the info can be gone perpetually. It can’t be undone.

We suggest making a complete WordPress backup earlier than you go any additional. You can even back up your WordPress database alone in case you don’t need to again up your complete web site.

Now, we’ll present you two strategies to shortly again up your WordPress database earlier than the reset. You possibly can select the one which works finest for you.

Technique 1: Make WordPress Database Backup Utilizing Duplicator

Duplicator is the best WordPress backup plugin in the marketplace. It means that you can simply again up your WordPress web site and shortly restore it from the backup.

First, you might want to set up and activate the Duplicator plugin. For extra particulars, see our step-by-step information on how to install a WordPress plugin.

Notice: There’s additionally a free version of Duplicator that you should utilize. Nonetheless, we suggest upgrading to the paid plan to unlock the complete potential of the plugin.

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

Subsequent, you might want to present a reputation to your backup.

Click on on the ‘Subsequent’ button to proceed.

Duplicator will now scan your WordPress website and present the scan outcomes.

It might present some notices, like in case you don’t have a WordPress safety plugin put in or are utilizing an outdated model of WordPress.

You possibly can ignore these notices. If every little thing else seems to be good, then click on on the ‘Construct’ button to proceed.

The plugin will again up your WordPress database and present you the obtain choices.

Merely click on on the ‘Obtain’ and ‘Each Recordsdata’ buttons to proceed.

Duplicator will now ship each the Archive and the Installer information as downloads to your pc.

Technique 2: Create a Database Backup Utilizing Superior WP Reset

For this technique, you can be utilizing the Superior WP Reset plugin. It’s the similar plugin that you’ll use within the subsequent step to reset your WordPress database.

Nonetheless, the draw back of this backup strategy is that you’ll have to restore your WordPress database utilizing phpMyAdmin.

First, you might want to set up and activate the Advanced WP Reset plugin. For extra particulars, see our step-by-step information on how to install a WordPress plugin.

Upon activation, go to the Instruments » Superior WP Reset web page and swap to the ‘Snapshots’ tab.

Present a reputation to your backup, after which click on the ‘Take Snapshot’ button.

The plugin will now put together a duplicate of your database and retailer it as a backup. You will note it listed beneath the Accessible Snapshots part.

Nonetheless, if you reset your WordPress database, the plugin will even delete this snapshot. You must put it aside in your pc to make use of it later.

Click on on the plus [+] icon to broaden the snapshot choices, after which click on on the ‘Obtain’ button.

Your database backup will now obtain as an SQL file to your pc.

Step 2: Reset Your WordPress Database to Default Settings

Now, you might want to set up and activate the Advanced WP Reset plugin. For extra particulars, see our step-by-step information on how to install a WordPress plugin.

Subsequent, go to the Instruments » Superior WP Reset web page and swap to the ‘Reset’ tab.

Below the Website Reset part, the plugin will present you all the info it would reset. This contains the next:

• Pages, posts, and feedback
• Customized database tables (created by you or a WordPress plugin put in in your web site)
• Customers aside from the present admin consumer
• Superior WP Reset plugin knowledge (together with snapshots and settings)

Under that, it would present you which ones knowledge won’t be deleted. This contains the next gadgets:

• The admin consumer account
• Recordsdata, uploads within the media library, themes, plugins, and extra. Nonetheless, any plugin or theme knowledge saved within the database can be deleted.
• Primary WordPress settings, together with web site title, WordPress handle, web site handle, timezone, and language choices
• Non-WordPress database tables. These tables don’t share the desk prefix set in your WordPress database settings.

If every little thing seems to be good, simply sort ‘Reset’ beneath the Warning label after which click on the ‘Reset’ button.

It will carry up one other popup warning.

Merely click on the ‘Reset Now’ button to proceed.

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

As soon as completed, you will note successful message.

Now you can proceed utilizing your web site with the default database settings.

Notice: Upon reset, the plugin will recreate the default WordPress content material that comes with a contemporary set up of WordPress. It features a weblog publish titled ‘Hey World’, ‘A Pattern Web page’ beneath Pages, and a pattern remark beneath Feedback. Be happy to delete these manually.

Step 3: Restore WordPress Database From Backup (Non-obligatory)

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

Technique 1: Restore Duplicator Database Backup

Should you created your WordPress database backup utilizing the Duplicator plugin, then right here is how you’ll restore your web site.

Through the database reset, the Superior WP Reset plugin will deactivate all different WordPress plugins put in in your web site.

Go to the Plugins web page within the WordPress admin space to activate the Duplicator plugin.

As soon as the plugin is activated, you might want to go to the Duplicator » Import web page.

Right here, you might want to add the Archive file you downloaded in step one.

Subsequent, the plugin will scan your archive file and present you the package deal particulars.

If every little thing seems to be good, simply click on the ‘Proceed’ button to start the import.

On the subsequent display screen, chances are you’ll be requested to verify that you simply need to proceed with no restoration level.

Since you have already got the newest backup, it’s protected to proceed with out making a restoration level.

Scroll right down to the underside of the web page.

You will note the variety of posts, pages, feedback, and media beneath the system overview. Click on on the ‘Launch Installer’ button to proceed.

It will launch the Duplicator installer.

Upon launch, the installer will routinely select ‘Restore single web site’ as your restoration sort.

Scroll right down to the Validation part.

Right here, you’ll once more see the warning in regards to the restoration level. You must test the field subsequent to the ‘I’ve learn and settle for all phrases and notices’ choice.

Click on on the ‘Subsequent’ button to proceed.

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

Duplicator will now begin importing your web site from the backup and restore your WordPress database.

As soon as completed, you will note successful message with a button to log in to the WordPress admin area.

Technique 2: Restore Database Backup from SQL File

Should you saved your WordPress database technique utilizing the Superior WP Reset plugin’s Snapshots software, then right here is how you’ll restore the database.

First, you might want to open up phpMyAdmin. It’s a web-based software that means that you can simply carry out database operations utilizing a pleasant interface.

If the web site you are attempting to retailer is hosted in your internet server, then log in to your WordPress hosting account management panel (cPanel).

From right here, you might want to discover the Database part and click on on the ‘phpMyAdmin’ button.

It will open phpMyAdmin in a brand new browser tab.

Then again, in case you had been engaged on a neighborhood web site in your pc, then you possibly can open phpMyAdmin or an analogous software from the software program that you’re utilizing for native websites.

We suggest utilizing Local, which doesn’t include phpMyAdmin. As an alternative, it makes use of Open Adminer to handle databases.

As soon as you’re in phpMyAdmin, just remember to have chosen the database to your web site.

Choose all database tables in phpMyAdmin by clicking on the ‘Examine all’ field on the backside of the desk record. After that, choose ‘Drop’ from the ‘With chosen’ dropdown menu.

It will empty your WordPress database.

Now you can swap to the ‘Import’ tab on the prime and click on on the ‘Select File’ button to pick the SQL file you downloaded earlier.

After selecting the file, be at liberty to evaluate the on-screen choices. The default settings will work for many web sites.

Scroll down towards the underside of the web page and click on on the ‘Import’ button.

phpMyAdmin will now add your SQL file and run it.

After that, you will note successful message.

Now you can go to your web site and log in to see your database restored to its earlier settings.

We hope this text helped you learn to reset your WordPress database to default settings. You may additionally need to try our beginner’s guide to WordPress database management and our skilled picks for the best WordPress database plugins.

Should you appreciated this text, then please subscribe to our YouTube Channel for WordPress video tutorials. You can even discover us on Twitter and Facebook.