Skip to content
GPLWP Guides

How to reset and restore a WordPress site

Backup & Migration Time About 30–90 minutes 7 steps Updated 11 Oct 2026

BACKUP & MIGRATION
The short answer

Back up both your WordPress files and database before resetting anything. You can reset manually by creating a clean installation or clearing the database, then restore by uploading the files and importing the SQL database. A reset tool is faster for repeat testing and recovery.

The route
  1. 01Decide what reset means
  2. 02Create a complete backup
  3. 03Reset the site manually
  4. 04Restore the files first
  5. 05Import the database backup
  6. 06Check the restored site
  7. 07Use the faster recovery route

What you need

  • A complete WordPress backup containing files and a database export
  • Hosting, SFTP or FTP, and database access
  • Administrator or hosting-panel access
  • The correct domain and database credentials

Decide what reset means

A reset usually means removing content, settings, plugins or themes so you can start again. A restore means returning the site to a saved state. They are different operations, so do not reset first if your real goal is to recover the current site.

For a clean rebuild, a fresh directory and empty database are safer than deleting selected tables and files from a live installation. Selective deletion can leave old plugin data, uploads or database tables behind.

Create a complete backup

Back up the database and the WordPress files separately. The database contains posts, pages, users, settings and plugin data, while the files include themes, plugins, media, wp-config.php and other server files. You need both for a full restore.

Download the SQL export and file archive, store them somewhere away from the server, and record the database name, host, user, password and table prefix from wp-config.php. A backup that contains only the files cannot restore your content.

Reset the site manually

For a genuine clean start, use your host to create a new database and install a fresh WordPress copy, or use WP-CLI if your server provides it. The command wp db reset --yes removes all tables from the current database, so confirm the site path and backup before running it.

Do not use a database reset on a live site just to troubleshoot one plugin. It can remove users, content and settings, and support reports regularly mention locked-out administrators after selecting every table. Keep the old database and files until the replacement site works.

Restore the files first

Upload the backed-up WordPress files through SFTP, FTP or your hosting file manager. Restore the core files, wp-content, uploads, themes, plugins and any required server files. If you are restoring to a different database, edit wp-config.php so its database credentials and table prefix match the destination.

For a clean replacement, remove old files that are not in the backup rather than only overwriting existing files. Leftover plugins or modified files can keep causing the original problem. WordPress documentation recommends restoring the files before importing the database.

Import the database backup

Use phpMyAdmin, Adminer or WP-CLI to import the SQL file into the destination database. With WP-CLI, the documented command is wp db import backup.sql. Import into the database named in wp-config.php, and check that the table prefix in the imported tables matches the prefix in the configuration file.

If the site is moving to a new domain, update the stored site address and replace old URLs carefully. Do not run a simple find-and-replace across serialized data; use a tool that understands serialized values or follow your host's migration procedure. The siteurl and home values are common causes of redirect loops and a missing dashboard after migration.

Check the restored site

Open the homepage and /wp-admin, test user login, check media, forms, search, permalinks and any shop or membership features. In the dashboard, visit Settings > Permalinks and save the settings once to refresh rewrite rules if links return 404 errors.

Clear page, object and CDN caches, then check the PHP error log if you see a blank page or critical error. If the restore shows the WordPress installation screen, check the database credentials and table prefix before importing again. Keep the original backup untouched until every important function passes.

Use the faster recovery route

For developers who reset sites repeatedly, WP Reset PRO can shorten the process with one-click reset options, database snapshots and recovery tools. It is useful for testing changes or troubleshooting without rebuilding the site each time.

Before using any automated reset, read which tables, files, users and uploads the selected operation affects. Take a fresh snapshot first, and treat a reset as destructive unless the tool clearly offers a recovery point.

The fast route

Let WP Reset PRO do it

One-click resets, database snapshots, and recovery; best for developers testing changes or troubleshooting without rebuilding a site.

Get WP Reset PRO

Sources

  1. developer.wordpress.org /advanced-administration/security/backup/?utm_source=openai
  2. developer.wordpress.org /cli/commands/db/?utm_source=openai
  3. developer.wordpress.com /docs/guides/manually-restore-backup/?utm_source=openai
  4. wordpress.org /support/topic/wp_-tables-gone-after-restoration-of-backup/?…

Questions

Can I reset WordPress without losing my content?
Yes, but only if you choose a reset that leaves the database content and uploads intact, and you have a verified backup first. Resetting plugins, themes or settings is different from deleting database tables. A full database reset removes posts, pages, users and configuration, while deleting files can remove media and custom code. Check the exact scope before confirming.
What must a WordPress backup contain for a full restore?
A full backup must contain both the WordPress files and a database export. The database holds content, users and settings, while the files hold core code, themes, plugins, uploads and configuration. Restoring only files can produce a site with missing content; restoring only the database can leave missing themes, plugins or media.
Why does my restored WordPress site show the installation screen?
The installation screen usually means WordPress cannot find the expected tables or is connected to the wrong database. Check the database name and credentials in <code>wp-config.php</code>, then compare its table prefix with the imported table names. An empty database, failed SQL import or mismatched prefix can all make an existing site appear new.
Do I need to change the URL when restoring to another domain?
Yes, when the restored site uses a different domain or directory, its stored URLs must be updated. At minimum, check the <code>siteurl</code> and <code>home</code> values, then perform a serialized-data-safe URL replacement for links inside content and settings. If the domain is unchanged, do not alter URLs unnecessarily.
Is a plugin required to reset and restore WordPress?
No. You can do the job manually with a file transfer tool, phpMyAdmin or WP-CLI, provided you have hosting and database access. The manual route is fine for occasional work, but it is easy to import into the wrong database, leave old files behind or lose administrator access. A reset-and-recovery plugin is more convenient for frequent staging and troubleshooting work.