How to Manually Restore Your WordPress Database?

Wondering How to Manually Restore Your WordPress Database? If yes, then I have got you covered. There are quite a lot of situations in which one would want to reset WordPress database manually.

For example, if we have lost access to the WordPress blog, or our WordPress website is hacked or anything. Restoring a WordPress database manually is not a really easy job.So in case if you want to know how to manually restore your WordPress database, keep on reading:

How to Manually Restore Your WordPress Database?

Step 1: Delete the Database

First of all, you will need to delete your database. This is the most important step before you step down to any other steps. Without following this step, you will be stuck with everything. So you better follow this step very carefully.

However, you should also know that deleting the database will completely remove your content and settings from WordPress. Plus, these settings are not reversible. So be sure that you are ready to lose all your data before moving to the next step.

So, first of all, you have to log in to the cPanel of your web hosting.

After that, you have to go to the MySQL databases option under the Databases > MySQL Databases section. Once you are on this page, you will find a list of all the databases connected to your WordPress website.

So start with identifying your WordPress database and copy and paste the name into a text file. Then you will have to delete the database using the delete button from the actions column, and it will wipe out your old WordPress database completely.

Step 2: Create A Database

Now that you have deleted the old database, you will need to create a new database. Since WordPress requires a database to run. Hence it is an important step that you have to follow.

So after deleting the old database, you will still be on the same cPanel page. So from here you have to find the create a new database option. Then you will need to enter the same database name that you have deleted previously.

After click on create database, the page will refresh and you will get to see a name pop up again under the current databases area. Over here you will need to add a user to the database section. You can simply enter your old username and password. Then select the matching database and username from the drop down menu and click on add user.

If you cannot find the old user, you may need to create it manually. You can easily do so from the Add a new user section. If possible, you use the same username and password as your old database user. You can easily find these details in your website’s wp-config.php file. The file will be present in the root folder.

Step 3: Delete Unnecessary Files

When you delete the database, it does not delete all your files completely. Even after deleting your database there are quite a lot of other files which you need to delete as well. Such as your plugins, themes, uploads and so on. Even it is extremely important for you to clean them before starting your new website. Else, these files will eat a lot of your server space.

To remove, these files, you will need to look into the root folder and then into the wp-content folder. You can delete these files by login to the Cpanel. Or you use your favorite FTP application for the job. Then you will need to go to the public_html folder and find the wp-content folder delete the files.

Step 4: Reinstall WordPress

In the end, you have to reinstall your WordPress site. Simply from your Cpanel go to the WordPress option. After that follow all the steps that you usually follow and install WordPress again. Once done, you will be able to use your website again.


So that was all for your question that says How to Manually Restore Your WordPress Database. However, this is quite a lengthy process and a bit complicated too. But you can easily speed up the process by using WP Reset.

WP Reset is a free to use WordPress database reset tool which you can try out. Along with that, you can also give a try to the wphtaccess plugin which will allow you to edit .htaccess file from your WP Dashboard.

If you liked how this WordPress Reset plugin works, you should also check other products from the same developer like UnderConstructionPage, Google Maps Widget, Coming Soon & Maintenance Mode as well as Security Ninja.