{"id":760,"date":"2011-10-04T16:30:54","date_gmt":"2011-10-04T16:30:54","guid":{"rendered":"https:\/\/wordpress.org\/plugins-wp\/wordpress-database-reset\/"},"modified":"2025-12-03T19:21:28","modified_gmt":"2025-12-03T19:21:28","slug":"wordpress-database-reset","status":"publish","type":"plugin","link":"https:\/\/pcd.wordpress.org\/plugins\/wordpress-database-reset\/","author":9070621,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_crdt_document":"","version":"3.25","stable_tag":"3.25","tested":"6.9.4","requires":"4.2","requires_php":"5.2","requires_plugins":null,"header_name":"WP Database Reset","header_author":"WebFactory Ltd","header_description":"","assets_banners_color":"ffffff","last_updated":"2025-12-03 19:21:28","external_support_url":"","external_repository_url":"","donate_link":"","header_plugin_uri":"https:\/\/wordpress.org\/plugins\/wordpress-database-reset\/","header_author_uri":"https:\/\/www.webfactoryltd.com\/","rating":4.5,"author_block_rating":4.55,"active_installs":10000,"downloads":1495321,"num_ratings":77,"support_threads":0,"support_threads_resolved":0,"author_block_count":1,"sections":["description","faq","changelog"],"tags":{"1.0":{"tag":"1.0","author":"mousesports","date":"2011-10-04 16:34:12"},"1.2":{"tag":"1.2","author":"mousesports","date":"2011-10-07 15:36:34"},"1.2.1":{"tag":"1.2.1","author":"mousesports","date":"2011-10-07 15:59:04"},"1.2.2":{"tag":"1.2.2","author":"mousesports","date":"2011-10-07 16:01:28"},"1.3":{"tag":"1.3","author":"mousesports","date":"2011-10-12 19:31:07"},"1.4":{"tag":"1.4","author":"mousesports","date":"2011-10-18 19:40:54"},"2.0":{"tag":"2.0","author":"mousesports","date":"2011-10-24 20:03:14"},"2.1":{"tag":"2.1","author":"mousesports","date":"2012-12-11 18:59:02"},"2.3":{"tag":"2.3","author":"mousesports","date":"2013-10-30 23:49:11"},"2.3.1":{"tag":"2.3.1","author":"mousesports","date":"2013-10-31 03:12:49"},"2.3.2":{"tag":"2.3.2","author":"mousesports","date":"2015-05-13 01:57:25"},"3.0":{"tag":"3.0","author":"mousesports","date":"2015-09-26 04:32:36"},"3.0.1":{"tag":"3.0.1","author":"mousesports","date":"2015-09-26 12:55:13"},"3.0.2":{"tag":"3.0.2","author":"WebFactory","date":"2019-08-07 19:57:44"},"3.1":{"tag":"3.1","author":"WebFactory","date":"2019-11-09 15:13:05"},"3.15":{"tag":"3.15","author":"WebFactory","date":"2020-08-07 20:45:57"},"3.16":{"tag":"3.16","author":"WebFactory","date":"2020-10-01 17:37:36"},"3.17":{"tag":"3.17","author":"WebFactory","date":"2020-12-05 15:17:56"},"3.18":{"tag":"3.18","author":"WebFactory","date":"2021-01-30 18:06:06"},"3.19":{"tag":"3.19","author":"WebFactory","date":"2021-02-25 18:56:48"},"3.20":{"tag":"3.20","author":"WebFactory","date":"2021-07-21 20:16:17"},"3.21":{"tag":"3.21","author":"WebFactory","date":"2022-11-03 13:46:00"},"3.22":{"tag":"3.22","author":"WebFactory","date":"2023-11-19 10:41:20"},"3.23":{"tag":"3.23","author":"WebFactory","date":"2024-03-26 19:33:03"},"3.24":{"tag":"3.24","author":"WebFactory","date":"2025-04-16 13:11:28"},"3.25":{"tag":"3.25","author":"WebFactory","date":"2025-12-03 19:21:28"}},"upgrade_notice":[],"ratings":{"1":8,"2":0,"3":1,"4":1,"5":67},"assets_icons":{"icon-128x128.png":{"filename":"icon-128x128.png","revision":2137639,"resolution":"128x128","location":"assets","locale":""},"icon-256x256.png":{"filename":"icon-256x256.png","revision":2137639,"resolution":"256x256","location":"assets","locale":""}},"assets_banners":{"banner-772x250.jpg":{"filename":"banner-772x250.jpg","revision":1253825,"resolution":"772x250","location":"assets","locale":""}},"assets_blueprints":{},"all_blocks":[],"tagged_versions":["1.0","1.2","1.2.1","1.2.2","1.3","1.4","2.0","2.1","2.3","2.3.1","2.3.2","3.0","3.0.1","3.0.2","3.1","3.15","3.16","3.17","3.18","3.19","3.20","3.21","3.22","3.23","3.24","3.25"],"block_files":[],"assets_screenshots":{"screenshot-1.gif":{"filename":"screenshot-1.gif","revision":2137340,"resolution":"1","location":"assets","locale":""}},"screenshots":{"1":"The WP Database Reset plugin page"},"jetpack_post_was_ever_published":false},"plugin_section":[],"plugin_tags":[4683,4684,4981,4982,4983],"plugin_category":[54,59],"plugin_contributors":[78032],"plugin_business_model":[],"class_list":["post-760","plugin","type-plugin","status-publish","hentry","plugin_tags-database-reset","plugin_tags-reset","plugin_tags-reset-wp","plugin_tags-wordpress-reset","plugin_tags-wp-reset","plugin_category-security-and-spam-protection","plugin_category-utilities-and-tools","plugin_contributors-webfactory","plugin_committers-talextech","plugin_committers-webfactory","plugin_support_reps-gordano","plugin_support_reps-talextech"],"banners":{"banner":"https:\/\/ps.w.org\/wordpress-database-reset\/assets\/banner-772x250.jpg?rev=1253825","banner_2x":false,"banner_rtl":false,"banner_2x_rtl":false},"icons":{"svg":false,"icon":"https:\/\/ps.w.org\/wordpress-database-reset\/assets\/icon-128x128.png?rev=2137639","icon_2x":"https:\/\/ps.w.org\/wordpress-database-reset\/assets\/icon-256x256.png?rev=2137639","generated":false},"screenshots":[{"src":"https:\/\/ps.w.org\/wordpress-database-reset\/assets\/screenshot-1.gif?rev=2137340","caption":"The WP Database Reset plugin page"}],"raw_content":"<!--section=description-->\n<p>If you need more reset tools install the free, advanced <a href=\"https:\/\/wordpress.org\/plugins\/wp-reset\/\">WP Reset<\/a> plugin. It has a lot more reset tools to individually reset plugins, themes, transients and media. You can also create database snapshots to restore your WP site with one click if you make a mistake.<\/p>\n\n<p>The WordPress Database Reset plugin allows you to <strong>reset the database<\/strong> (all tables or the ones you choose) back to its default settings without having to go through the WordPress 5 minute installation or having to modify any files.<\/p>\n\n<p><strong>Features<\/strong><\/p>\n\n<ul>\n<li>Extremely fast one click process to reset the WordPress database tables<\/li>\n<li>Choose to reset the entire database or specific database tables<\/li>\n<li>Secure and super simple to use<\/li>\n<li>Safe - it's not possible to accidentally click reset<\/li>\n<li>Prefer the command line? Reset the database in one command<\/li>\n<li>Excellent for theme and plugin developers who need to clean the database of any unnecessary content<\/li>\n<\/ul>\n\n<p><strong>Command Line<\/strong><\/p>\n\n<p>Once activated, you can use the WordPress Database Reset plugin with <a href=\"http:\/\/wp-cli.org\/\">WordPress CLI<\/a>. List of WP-CLI commands:<\/p>\n\n<p>Reset all tables:<\/p>\n\n<pre><code>wp reset database\n<\/code><\/pre>\n\n<p>Specify a list of tables to reset:<\/p>\n\n<pre><code>wp reset database --tables='users, posts, comments, options'\n<\/code><\/pre>\n\n<p>The current theme and plugins will be reactivated by default. You can disable them like so:<\/p>\n\n<pre><code>wp reset database --no-reactivate\n<\/code><\/pre>\n\n<p>List table names:<\/p>\n\n<pre><code>wp reset list\n<\/code><\/pre>\n\n<p><strong>Support<\/strong><\/p>\n\n<p>Create a new post in the <a href=\"https:\/\/wordpress.org\/support\/plugin\/wordpress-database-reset\">WordPress Database Reset support forum<\/a>.<\/p>\n\n<p><strong>Want to help out?<\/strong><\/p>\n\n<ul>\n<li>Provide new <a href=\"https:\/\/translate.wordpress.org\/projects\/wp-plugins\/wordpress-database-reset\">language translations<\/a><\/li>\n<li>Want to help others that might be having issues? <a href=\"https:\/\/wordpress.org\/support\/plugin\/wordpress-database-reset\">Answer questions on the support forum<\/a>.<\/li>\n<li>Rate the plugin - <a href=\"https:\/\/wordpress.org\/support\/plugin\/wordpress-database-reset\/reviews\/#new-post\">rate it<\/a><\/li>\n<\/ul>\n\n<p>WP Database Reset was originally developed in October 2011 by <a href=\"https:\/\/github.com\/chrisberthe\">Chris Berthe<\/a>. Please do not send him any support questions. If you need assistance the <a href=\"https:\/\/wordpress.org\/support\/plugin\/wordpress-database-reset\/\">official forum<\/a> is the best and fastest way to get it.<\/p>\n\n<!--section=faq-->\n<dl>\n<dt id='how%20to%20disable%20this%20plugin%3F'><h3>How to disable this plugin?<\/h3><\/dt>\n<dd><p>Just use standard Plugin overview page in WordPress admin section and deactivate it or rename plugin folder \/wp-content\/plugins\/wordpress-database-reset\/ over FTP access.<\/p><\/dd>\n<dt id='how%20can%20i%20report%20security%20bugs%3F'><h3>How can I report security bugs?<\/h3><\/dt>\n<dd><p>You can report security bugs through the Patchstack Vulnerability Disclosure Program. The Patchstack team help validate, triage and handle any security vulnerabilities. <a href=\"https:\/\/patchstack.com\/database\/vdp\/wordpress-database-reset\">Report a security vulnerability.<\/a><\/p><\/dd>\n\n<\/dl>\n\n<!--section=changelog-->\n<h4>3.25<\/h4>\n\n<ul>\n<li>2025\/08\/04<\/li>\n<li>minor code fixes<\/li>\n<\/ul>\n\n<h4>3.24<\/h4>\n\n<ul>\n<li>2024\/06\/30<\/li>\n<li>minor security fix<\/li>\n<\/ul>\n\n<h4>3.23<\/h4>\n\n<ul>\n<li>2024\/02\/19<\/li>\n<li>minor security fix<\/li>\n<\/ul>\n\n<h4>3.22<\/h4>\n\n<ul>\n<li>2022\/11\/22<\/li>\n<li>minor security fixes<\/li>\n<\/ul>\n\n<h4>3.21<\/h4>\n\n<ul>\n<li>2021\/07\/29<\/li>\n<li>fix for WP 5.8<\/li>\n<\/ul>\n\n<h4>3.20<\/h4>\n\n<ul>\n<li>2021\/04\/26<\/li>\n<li>still trying to warn people that this plugin will soon be discontinued<\/li>\n<\/ul>\n\n<h4>3.19<\/h4>\n\n<ul>\n<li>2021\/02\/25<\/li>\n<li>continuing to phase out the plugin in favor of WP Reset<\/li>\n<\/ul>\n\n<h4>3.18<\/h4>\n\n<ul>\n<li>2021\/01\/30<\/li>\n<li>added flyout menu<\/li>\n<li>started to phase out this plugin in favor of WP Reset<\/li>\n<\/ul>\n\n<h4>3.17<\/h4>\n\n<ul>\n<li>2020\/10\/06<\/li>\n<li>license fix<\/li>\n<li>added promo for WP 301 Redirects<\/li>\n<\/ul>\n\n<h4>3.16<\/h4>\n\n<ul>\n<li>2020\/09\/01<\/li>\n<li>fixed an issue with select tables element<\/li>\n<\/ul>\n\n<h4>3.15<\/h4>\n\n<ul>\n<li>2020\/01\/14<\/li>\n<li>security fixes - thanks to Chloe from Wordfence<\/li>\n<li>80k installations; 761,300 downloads<\/li>\n<\/ul>\n\n<h4>3.1<\/h4>\n\n<ul>\n<li>2019\/08\/13<\/li>\n<li>WebFactory took over development<\/li>\n<li>minor improvements in GUI and messaging<\/li>\n<li>fixed a nasty bug related to admin user ID not being 1<\/li>\n<li>70k installations; 665,500 downloads<\/li>\n<\/ul>\n\n<h4>3.0.2<\/h4>\n\n<ul>\n<li>Fix for plugin page not showing up in tools menu (on some hosting providers)<\/li>\n<li>Update how session tokens were being restored<\/li>\n<li>Remove unnecessary nonce<\/li>\n<li>Bump 'requires at least' to version 4.2<\/li>\n<li>Change 'theme_data' to 'theme_plugin_data'<\/li>\n<\/ul>\n\n<h4>3.0.1<\/h4>\n\n<ul>\n<li>Fix plugin disabled after update, thanks to Ulrich Pogson<\/li>\n<li>Update the pot file<\/li>\n<\/ul>\n\n<h4>3.0.0<\/h4>\n\n<ul>\n<li>Completely re-written from scratch<\/li>\n<li>Add extended WP_CLI command class<\/li>\n<li>Clean up admin interface<\/li>\n<li>Remove unnecessary help tabs<\/li>\n<li>Submit button is now deactivated until user inputs security code<\/li>\n<li>Add PayPal donation button<\/li>\n<li>Remove outdated localization files<\/li>\n<li>Update the text domain to match slug for translate.wordpress.org<\/li>\n<\/ul>\n\n<h4>2.3.2<\/h4>\n\n<ul>\n<li>Add option to keep active theme, thanks to Ulrich Pogson<\/li>\n<li>Adhere to WordPress PHP coding syntax standards<\/li>\n<li>Delete the user session and recreate it<\/li>\n<li>Separate the backup_tables method into two new methods<\/li>\n<li>Reset only WP tables and not custom tables<\/li>\n<li>French language updates, thanks to Fx Benard<\/li>\n<li>Fix for undefined variable: backup_tables<\/li>\n<\/ul>\n\n<h4>2.3.1<\/h4>\n\n<ul>\n<li>Fixed bug where reactivate plugins div was not displaying on 'options' table select<\/li>\n<\/ul>\n\n<h4>2.3<\/h4>\n\n<ul>\n<li>Removed deprecated function $wpdb-&gt;escape(), replaced with esc_sql()<\/li>\n<li>Add German translation, thanks to Ulrich Pogson<\/li>\n<li>Updated screenshot-1.png<\/li>\n<li>Renamed default localization file<\/li>\n<li>Fixed broken if conditional during code clean up for version 2.2<\/li>\n<\/ul>\n\n<h4>2.2<\/h4>\n\n<ul>\n<li>Fixed scripts and styles to only load on plugin page<\/li>\n<li>Formatted code to meet WordPress syntax standards<\/li>\n<\/ul>\n\n<h4>2.1<\/h4>\n\n<ul>\n<li>Replaced 3.3 deprecated get_userdatabylogin() with get_user_by()<\/li>\n<li>Updated deprecated add_contextual_help() with add_help_tab()<\/li>\n<li>Small change in condition check for backup tables<\/li>\n<li>Removed custom _rand_string() with core wp_generate_password()<\/li>\n<li>Added Portuguese translation - thanks to Fernando Lopes<\/li>\n<\/ul>\n\n<h4>2.0<\/h4>\n\n<ul>\n<li>Added functionality to be able to select which tables you want to reset, rather than having to reset the entire database.<\/li>\n<li>Added bsmSelect for the multiple select.<\/li>\n<li>Modified screenshot-1.png.<\/li>\n<li>Fixed redirect bug<\/li>\n<li>'Reactivate current plugins after reset' only shows if the options table is selected from the dropdown.<\/li>\n<\/ul>\n\n<h4>1.4<\/h4>\n\n<ul>\n<li>Made quite a few changes to the translation files<\/li>\n<li>Renamed French translation file for plugin format, not theme format<\/li>\n<li>Optimized (until potential version 2.0)<\/li>\n<\/ul>\n\n<h4>1.3<\/h4>\n\n<ul>\n<li>Replaced reactivation option for all currently active plugins (not just this plugin)<\/li>\n<li>Updated language files<\/li>\n<\/ul>\n\n<h4>1.2<\/h4>\n\n<ul>\n<li>Added capability to manually select whether or not plugin should be reactivated upon reset<\/li>\n<li>Modified class name to avoid potential conflicts with WordPress core<\/li>\n<li>Modified wp_mail override<\/li>\n<li>Removed deprecated user level for WordPress 3.0+<\/li>\n<li>Fixed small bug where if admin user did not have admin capabilities, it would tell the user they did<\/li>\n<\/ul>\n\n<h4>1.0<\/h4>\n\n<ul>\n<li>First version<\/li>\n<li>2011-10-04<\/li>\n<\/ul>","raw_excerpt":"Skip reinstalling WP to reset it &amp; reset the WordPress database back to its original state with 1-click.","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/760","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=760"}],"author":[{"embeddable":true,"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/webfactory"}],"wp:attachment":[{"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=760"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=760"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=760"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=760"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=760"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=760"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}