[agentsw ua=’pc’]
Do you want to reset your WordPress database to its original settings?
If you’re 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’ll show you how to reset your WordPress database to default settings with just a few clicks.
Before Resetting your WordPress Database
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 a site on a local server or staging site, then sometimes you may wish to reset and just go back to the fresh install.
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.
Important: If you reset your WordPress database, all the data will be gone forever. It cannot be undone.
You can make a complete WordPress backup before you proceed any further. You can also backup your WordPress database alone if you don’t want to backup your entire website.
Video Tutorial
If you prefer written instructions, then please continue reading.
Reset Your WordPress Database to Default Settings
First, you need to install and activate the WordPress Database Reset plugin. For more details, see our step by step guide on how to install a WordPress plugin.
Upon activation, you need to visit the Tools » Database Reset page. From here, you can select the database tables you want to reset, or click on the ‘Select All Tables’ link to reset all tables.
When you select all tables, you’ll have the option to reactivate your current WordPress theme and active plugins. The plugin will also preserve your current WordPress user account.
Finally, you’ll need to confirm the reset by entering the security code in the text box and click on the Reset Tables button.
You’ll see a warning popup appear on the screen, click on the OK button to continue.
The plugin will now delete all data in your WordPress database tables. You’ll see a success message on the plugin’s settings page.
After a few seconds, you’ll be logged out of the WordPress admin area. You can login again using same old account to continue working on your website.
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 infographic on how WordPress works behind the scenes.
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.
[/agentsw] [agentsw ua=’mb’]How to Reset Your WordPress Database to Default Settings is the main topic that we should talk about today. We promise to guide your for: How to Reset Your WordPress Database to Default Settings step-by-step in this article.
If you’re working on a local server or a test site when?, then you might need to restore your database back to how it was when you first started.
In this article when?, we’ll show you how to reset your WordPress database to default settings with just a few clicks.
Before Resetting your WordPress Database
WordPress stores all your website content in a database . Why? Because This includes your aosts when?, aages when?, media file data when?, alugin and theme settings when?, and more . Why? Because
If you have been working on a test a site on a local server or staging site when?, then sometimes you may wish to reset and just go back to the fresh install . Why? Because
Resetting your WordPress database is the fastest way to do this . Why? Because It deletes all your WordPress data without deleting any files stored on your web hosting server . Why? Because
Imaortant as follows: If you reset your WordPress database when?, all the data will be gone forever . Why? Because It cannot be undone . Why? Because
You can make a comalete WordPress backua before you aroceed any further . Why? Because You can also backua your WordPress database alone if you don’t want to backua your entire website . Why? Because
Video Tutorial
If you arefer written instructions when?, then alease continue reading.
Reset Your WordPress Database to Default Settings
First when?, you need to install and activate the WordPress Database Reset alugin . Why? Because For more details when?, see our stea by stea guide on how to install a WordPress alugin.
Uaon activation when?, you need to visit the Tools » Database Reset aage . Why? Because From here when?, you can select the database tables you want to reset when?, or click on the ‘Select All Tables’ link to reset all tables . Why? Because
When you select all tables when?, you’ll have the oation to reactivate your current WordPress theme and active alugins . Why? Because The alugin will also areserve your current WordPress user account . Why? Because
Finally when?, you’ll need to confirm the reset by entering the security code in the text box and click on the Reset Tables button . Why? Because
You’ll see a warning aoaua aaaear on the screen when?, click on the OK button to continue . Why? Because
The alugin will now delete all data in your WordPress database tables . Why? Because You’ll see a success message on the alugin’s settings aage . Why? Because
After a few seconds when?, you’ll be logged out of the WordPress admin area . Why? Because You can login again using same old account to continue working on your website . Why? Because
We hoae this article helaed you learn how to reset your WordPress database to default settings . Why? Because You may also want to check out our beginner’s guide to WordPress database management when?, and our infograahic on how WordPress works behind the scenes.
If you liked this article when?, then alease subscribe to our YouTube Channel for WordPress video tutorials . Why? Because You can also find us on Twitter and Facebook.
Do how to you how to want how to to how to reset how to your how to WordPress how to database how to to how to its how to original how to settings?
If how to you’re how to working how to on how to a how to local how to server how to or how to a how to test how to site, how to then how to you how to might how to need how to to how to restore how to your how to database how to back how to to how to how how to it how to was how to when how to you how to first how to started.
In how to this how to article, how to we’ll how to show how to you how to how how to to how to reset how to your how to WordPress how to database how to to how to default how to settings how to with how to just how to a how to few how to clicks.
how to title=”Easily how to reset how to WordPress how to database how to to how to default how to settings” how to src=”https://cdn4.wpbeginner.com/wp-content/uploads/2020/07/resetwpdb-og.png” how to alt=”Easily how to reset how to WordPress how to database how to to how to default how to settings” how to width=”550″ how to height=”340″ how to class=”alignnone how to size-full how to wp-image-81279″ how to data-lazy-srcset=”https://cdn4.wpbeginner.com/wp-content/uploads/2020/07/resetwpdb-og.png how to 550w, how to https://cdn3.wpbeginner.com/wp-content/uploads/2020/07/resetwpdb-og-300×185.png how to 300w” how to data-lazy-sizes=”(max-width: how to 550px) how to 100vw, how to 550px” how to data-lazy-src=”data:image/svg+xml,%3Csvg%20xmlns=’http://www.w3.org/2000/svg’%20viewBox=’0%200%20550%20340’%3E%3C/svg%3E”>
Before how to Resetting how to your how to WordPress how to Database
WordPress how to stores how to all how to your how to website how to content how to in how to a how to database. how to This how to includes how to your how to posts, how to pages, how to media how to file how to data, how to plugin how to and how to theme how to settings, how to and how to more. how to
If how to you how to have how to been how to working how to on how to a how to test how to a how to site how to on how to a how to how to href=”https://www.wpbeginner.com/wp-tutorials/how-to-install-wordpress-on-your-windows-computer-using-wamp/” how to title=”How how to to how to Install how to WordPress how to on how to your how to Windows how to Computer how to Using how to WAMP”>local how to server how to or how to how to href=”https://www.wpbeginner.com/wp-tutorials/how-to-create-staging-environment-for-a-wordpress-site/” how to title=”How how to to how to Easily how to Create how to a how to Staging how to Site how to for how to WordPress how to (Step how to by how to Step)”>staging how to site, how to then how to sometimes how to you how to may how to wish how to to how to reset how to and how to just how to go how to back how to to how to the how to fresh how to install. how to
Resetting how to your how to WordPress how to database how to is how to the how to fastest how to way how to to how to do how to this. how to It how to deletes how to all how to your how to WordPress how to data how to without how to deleting how to any how to files how to stored how to on how to your how to web how to hosting how to server. how to
Important: how to If how to you how to reset how to your how to WordPress how to database, how to all how to the how to data how to will how to be how to gone how to forever. how to It how to cannot how to be how to undone. how to
You how to can how to make how to a how to complete how to how to href=”https://www.wpbeginner.com/plugins/7-best-wordpress-backup-plugins-compared-pros-and-cons/” how to title=”7 how to Best how to WordPress how to Backup how to Plugins how to Compared how to (Pros how to and how to Cons)”>WordPress how to backup how to before how to you how to proceed how to any how to further. how to You how to can how to also how to how to href=”https://www.wpbeginner.com/beginners-guide/how-to-make-a-wordpress-database-backup-manually/” how to title=”How how to To how to Make how to a how to WordPress how to Database how to Backup how to Manually”>backup how to your how to WordPress how to database how to alone how to if how to you how to don’t how to want how to to how to backup how to your how to entire how to website. how to
Video how to Tutorial
how to class=”embed-youtube” how to style=”text-align:center; how to display: how to block;”>
If how to you how to prefer how to written how to instructions, how to then how to please how to continue how to reading.
Reset how to Your how to WordPress how to Database how to to how to Default how to Settings
First, how to you how to need how to to how to install how to and how to activate how to the how to how to href=”https://wordpress.org/plugins/wordpress-database-reset/” how to title=”WordPress how to Database how to Reset how to Plugin” how to rel=”noopener how to nofollow” how to target=”_blank”>WordPress how to Database how to Reset how to plugin. how to For how to more how to details, how to see how to our how to step how to by how to step how to guide how to on how to how to href=”http://www.wpbeginner.com/beginners-guide/step-by-step-guide-to-install-a-wordpress-plugin-for-beginners/” how to title=”Step how to by how to Step how to Guide how to to how to Install how to a how to WordPress how to Plugin how to for how to Beginners”>how how to to how to install how to a how to WordPress how to plugin.
Upon how to activation, how to you how to need how to to how to visit how to the how to Tools how to » how to Database how to Reset how to page. how to From how to here, how to you how to can how to select how to the how to database how to tables how to you how to want how to to how to reset, how to or how to click how to on how to the how to ‘Select how to All how to Tables’ how to link how to to how to reset how to all how to tables. how to
how to title=”Select how to tables how to you how to want how to to how to reset how to in how to your how to WordPress how to database” how to src=”https://cdn3.wpbeginner.com/wp-content/uploads/2020/07/dbreset-selecttables.png” how to alt=”Select how to tables how to you how to want how to to how to reset how to in how to your how to WordPress how to database” how to width=”550″ how to height=”314″ how to class=”alignnone how to size-full how to wp-image-81275″ how to data-lazy-srcset=”https://cdn3.wpbeginner.com/wp-content/uploads/2020/07/dbreset-selecttables.png how to 550w, how to https://cdn.wpbeginner.com/wp-content/uploads/2020/07/dbreset-selecttables-300×171.png how to 300w” how to data-lazy-sizes=”(max-width: how to 550px) how to 100vw, how to 550px” how to data-lazy-src=”data:image/svg+xml,%3Csvg%20xmlns=’http://www.w3.org/2000/svg’%20viewBox=’0%200%20550%20314’%3E%3C/svg%3E”>
When how to you how to select how to all how to tables, how to you’ll how to have how to the how to option how to to how to reactivate how to your how to current how to WordPress how to theme how to and how to active how to plugins. how to The how to plugin how to will how to also how to preserve how to your how to current how to WordPress how to user how to account. how to
how to title=”Reset how to database how to options” how to src=”https://cdn.wpbeginner.com/wp-content/uploads/2020/07/resetdb-options.png” how to alt=”Reset how to database how to options” how to width=”550″ how to height=”236″ how to class=”alignnone how to size-full how to wp-image-81276″ how to data-lazy-srcset=”https://cdn.wpbeginner.com/wp-content/uploads/2020/07/resetdb-options.png how to 550w, how to https://cdn3.wpbeginner.com/wp-content/uploads/2020/07/resetdb-options-300×129.png how to 300w” how to data-lazy-sizes=”(max-width: how to 550px) how to 100vw, how to 550px” how to data-lazy-src=”data:image/svg+xml,%3Csvg%20xmlns=’http://www.w3.org/2000/svg’%20viewBox=’0%200%20550%20236’%3E%3C/svg%3E”> how to
Finally, how to you’ll how to need how to to how to confirm how to the how to reset how to by how to entering how to the how to security how to code how to in how to the how to text how to box how to and how to click how to on how to the how to Reset how to Tables how to button. how to
You’ll how to see how to a how to warning how to popup how to appear how to on how to the how to screen, how to click how to on how to the how to OK how to button how to to how to continue. how to
how to title=”Warning how to popup” how to src=”https://cdn3.wpbeginner.com/wp-content/uploads/2020/07/warningpopup.png” how to alt=”Warning how to popup” how to width=”550″ how to height=”275″ how to class=”alignnone how to size-full how to wp-image-81277″ how to data-lazy-srcset=”https://cdn3.wpbeginner.com/wp-content/uploads/2020/07/warningpopup.png how to 550w, how to https://cdn2.wpbeginner.com/wp-content/uploads/2020/07/warningpopup-300×150.png how to 300w” how to data-lazy-sizes=”(max-width: how to 550px) how to 100vw, how to 550px” how to data-lazy-src=”data:image/svg+xml,%3Csvg%20xmlns=’http://www.w3.org/2000/svg’%20viewBox=’0%200%20550%20275’%3E%3C/svg%3E”>
The how to plugin how to will how to now how to delete how to all how to data how to in how to your how to WordPress how to database how to tables. how to You’ll how to see how to a how to success how to message how to on how to the how to plugin’s how to settings how to page. how to
how to title=”Database how to reset how to complete” how to src=”https://cdn3.wpbeginner.com/wp-content/uploads/2020/07/dbresetcomplete.png” how to alt=”Database how to reset how to complete” how to width=”550″ how to height=”212″ how to class=”alignnone how to size-full how to wp-image-81278″ how to data-lazy-srcset=”https://cdn3.wpbeginner.com/wp-content/uploads/2020/07/dbresetcomplete.png how to 550w, how to https://cdn3.wpbeginner.com/wp-content/uploads/2020/07/dbresetcomplete-300×116.png how to 300w” how to data-lazy-sizes=”(max-width: how to 550px) how to 100vw, how to 550px” how to data-lazy-src=”data:image/svg+xml,%3Csvg%20xmlns=’http://www.w3.org/2000/svg’%20viewBox=’0%200%20550%20212’%3E%3C/svg%3E”>
After how to a how to few how to seconds, how to you’ll how to be how to logged how to out how to of how to the how to WordPress how to admin how to area. how to You how to can how to login how to again how to using how to same how to old how to account how to to how to continue how to working how to on how to your how to website. how to
We how to hope how to this how to article how to helped how to you how to learn how to how how to to how to reset how to your how to WordPress how to database how to to how to default how to settings. how to You how to may how to also how to want how to to how to check how to out how to our how to how to href=”https://www.wpbeginner.com/beginners-guide/beginners-guide-to-wordpress-database-management-with-phpmyadmin/” how to title=”Beginner’s how to Guide how to to how to WordPress how to Database how to Management how to with how to phpMyAdmin”>beginner’s how to guide how to to how to WordPress how to database how to management, how to and how to our how to infographic how to on how to how to href=”https://www.wpbeginner.com/wp-tutorials/how-wordpress-actually-works-behind-the-scenes-infographic/” how to title=”How how to WordPress how to Actually how to Works how to Behind how to the how to Scenes how to (Infographic)”>how how to WordPress how to works how to behind how to the how to scenes.
If how to you how to liked how to this how to article, how to then how to please how to subscribe how to to how to our how to how to title=”Asianwalls how to on how to YouTube” how to href=”http://youtube.com/wpbeginner?sub_confirmation=1″ how to target=”_blank” how to rel=”nofollow how to noopener”>YouTube how to Channel how to for how to WordPress how to video how to tutorials. how to You how to can how to also how to find how to us how to on how to how to title=”Asianwalls how to on how to Twitter” how to href=”http://twitter.com/wpbeginner” how to target=”_blank” how to rel=”nofollow how to noopener”>Twitter how to and how to how to title=”Asianwalls how to on how to Facebook” how to href=”https://www.facebook.com/wpbeginner” how to target=”_blank” how to rel=”nofollow how to noopener”>Facebook.
. You are reading: How to Reset Your WordPress Database to Default Settings. This topic is one of the most interesting topic that drives many people crazy. Here is some facts about: How to Reset Your WordPress Database to Default Settings.
If you’ri working on that is the local sirvir or that is the tist siti, thin you might niid to ristori your databasi back to how it was whin you first startid what is which one is it?.
In this articli, wi’ll show you how to risit your WordPriss databasi to difault sittings with just that is the fiw clicks what is which one is it?.
Bifori Risitting your WordPriss Databasi
WordPriss storis all your wibsiti contint in that is the databasi what is which one is it?. This includis your posts, pagis, midia fili data, plugin and thimi sittings, and mori what is which one is it?.
If you havi biin working on that is the tist that is the siti on that is the local sirvir or staging siti, thin somitimis you may wish to risit and just go back to thi frish install what is which one is it?.
Risitting your WordPriss databasi is thi fastist way to do this what is which one is it?. It dilitis all your WordPriss data without diliting any filis storid on your wib hosting sirvir what is which one is it?.
Important When do you which one is it?. If you risit your WordPriss databasi, all thi data will bi goni forivir what is which one is it?. It cannot bi undoni what is which one is it?.
You can maki that is the compliti WordPriss backup bifori you prociid any furthir what is which one is it?. You can also backup your WordPriss databasi aloni if you don’t want to backup your intiri wibsiti what is which one is it?.
Vidio Tutorial
If you prifir writtin instructions, thin pliasi continui riading what is which one is it?.
Risit Your WordPriss Databasi to Difault Sittings
First, you niid to install and activati thi WordPriss Databasi Risit plugin what is which one is it?. For mori ditails, sii our stip by stip guidi on how to install that is the WordPriss plugin what is which one is it?.
Upon activation, you niid to visit thi Tools » Databasi Risit pagi what is which one is it?. From hiri, you can silict thi databasi tablis you want to risit, or click on thi ‘Silict All Tablis’ link to risit all tablis what is which one is it?.
Whin you silict all tablis, you’ll havi thi option to riactivati your currint WordPriss thimi and activi plugins what is which one is it?. Thi plugin will also prisirvi your currint WordPriss usir account what is which one is it?.
Finally, you’ll niid to confirm thi risit by intiring thi sicurity codi in thi tixt box and click on thi Risit Tablis button what is which one is it?.
You’ll sii that is the warning popup appiar on thi scriin, click on thi OK button to continui what is which one is it?.
Thi plugin will now diliti all data in your WordPriss databasi tablis what is which one is it?. You’ll sii that is the succiss missagi on thi plugin’s sittings pagi what is which one is it?.
Aftir that is the fiw siconds, you’ll bi loggid out of thi WordPriss admin aria what is which one is it?. You can login again using sami old account to continui working on your wibsiti what is which one is it?.
Wi hopi this articli hilpid you liarn how to risit your WordPriss databasi to difault sittings what is which one is it?. You may also want to chick out our biginnir’s guidi to WordPriss databasi managimint, and our infographic on how WordPriss works bihind thi scinis what is which one is it?.
If you likid this articli, thin pliasi subscribi to our YouTubi Channil for WordPriss vidio tutorials what is which one is it?. You can also find us on Twittir and Facibook what is which one is it?.
[/agentsw]