Learn how to Restore WordPress Website from Database Backup Solely

How to Restore WordPress Site from Database Backup Only

Making a backup of your web site’s information and databases is all the time a good suggestion. The extra backups you make – the larger likelihood you’ll endure fewer penalties from unpredictable occasions. Whether or not you eliminated some information unintentionally by your self or your WordPress received compromised and your information have been corrupted by malware, it could nonetheless be attainable to revive your WordPress website. On this tutorial, you’ll learn to restore WordPress, even in case you have solely a MySQL database backup.

This technique of restoration is barely partial and also you won’t have the ability to recuperate all the things, nevertheless, WordPress shops most settings and information in its database. Thus, it is possible for you to to recuperate most of your WordPress web site solely out of your database.

What you’ll want

Earlier than you start this information, you’ll want the next:

  • Entry to your internet hosting management panel
  • MySQL database backup

Step 1 – Importing WordPress Database Backup

To begin with, we have to create an empty MySQL database. We’ll Import our MySQL database backup to it.

  1. Entry the internet hosting management panel and discover your MySQL Databases administration menu.
    Access MySQL Databases
  2. Create a database and assign a consumer to it. On this instance, Hostinger management panel gives the flexibility to create MySQL databases with customers assigned to them in a short time, we solely have to fill out the required data. Try this information, in case you are utilizing cPanel to handle your account.
    Hostinger Database creation
  3. Entry your newly created database through phpMyAdmin.
    phpMyAdmin Access
  4. Import the database you’ve saved out of your earlier WordPress set up. You are able to do this on Import part: merely choose the .SQL file (1), set format to SQL (2) and press the Go button (3). An in depth tutorial about how you can use phpMyAdmin’s import characteristic could be discovered right here.
    Import Database

IMPORTANT: Write down the MySQL database particulars: database identify, consumer and password, as you will have them within the subsequent step. Additionally, write down the Desk Prefix. You may see the Desk Prefix on the left aspect of phpMyAdmin.

Step 2 – Restoring WordPress

Because you solely have a MySQL database in the mean time, the following step must be fitting a contemporary WordPress occasion:

  1. Obtain the WordPress set up information from right here.
  2. Add the WordPress information to your internet hosting account. In case you are unsure how to do that, verify an in depth information on how you can installation WordPress right here.
  3. Entry your WordPress set up (by accessing your web site together with your browser) and select a language for the WordPress set up. As soon as you choose the language in your website, hit Let’s go! and you’ll proceed to the database configuration step. Use the knowledge of the database you’ve simply beforehand created.
    Database Connection Details
  4. If accomplished appropriately, on the finish of the set up, you will notice a message that WordPress is already put in.
    WordPress Already Installed

IMPORTANT: When you didn’t obtain this notification, you may have to re-do the entire course of. Double-check your Prefix setting.

Step 3 – Re-installing your Theme and Plugins

At this level, your web site ought to have your outdated posts and pages, settings, customized CSS information, customers. Nonetheless, with out your earlier themes and plugins, all of this is not going to seem because it did earlier than:

  • The very first thing you must do is re-install your theme. Merely installation the identical theme that you just’ve used as your default one earlier than. Be sure that to take a look at this information as a reminder on how you can simply installation WordPress themes.
  • Now re-install your beforehand put in plugins. Fortuitously, your database had a listing of beforehand put in and activated plugins, so while you entry your plugins menu, you will notice a listing of plugins which might be at the moment lacking.
    Missing Plugins in WordPress

Step 4 – Fixing Permalinks

Now that you just’ve regained most of your web site, you may nonetheless expertise points with it. Most definitely, your Permalinks gained’t be working as they have been and navigating in your web site will end in a 404 Web page Not Discovered error.

You may shortly repair your Permalinks by clicking on Settings in your Dashboard and accessing your Permalinks part. Click on Save Modifications on the backside, with out truly making any adjustments. This could refresh permalinks and repair them.

Fixing Permalinks

Step 5 – Fixing Lacking Pictures

Now comes the laborious half. Sadly, your database didn’t comprise photos out of your earlier web site. There is no such thing as a simple option to repair this situation. You will want to re-upload each picture that’s lacking.

That will help you discover which photos particularly are lacking, we shall be utilizing the Damaged Hyperlink Checker plugin.

  1. Similar to with most plugins for WordPress, you possibly can installation it through the official plugin repository by way of your WordPress admin space. Merely click on on Plugins in your Dashboard and choose Add New. Enter Damaged Hyperlink Checker within the Search Bar and installation the plugin. Be sure to activate the newly put in plugin.
    Installing the Plugin
  2. Entry your newly put in plugin through the Dashboard by clicking on Instruments and accessing Damaged Hyperlinks. You will note a listing of damaged/lacking hyperlinks, so this may enable you to decide which photos are lacking and their earlier location.
    Broken Link List
  3. Now merely reupload the lacking photos and, if essential, replace their hyperlinks.

Essentially the most unlucky state of affairs is while you now not have these photos. On this case, one of the best answer is checking an archived model of your web site. Archive.org is a good software for such instances and it may need a earlier, totally working model of your web site. It is possible for you to to obtain the lacking photos from there:

  1. Entry Archive.org. On the best of the web page you will notice the “Waybackmachine”. Enter your web site’s URL and hit ENTER key.
  2. If there are any snapshots obtainable of your web site, you will notice these blue circles round sure dates of the yr. Click on on these dates so as to entry a earlier model of your web site.
  3. After that, seek for the precise photos which might be lacking and obtain them from the archived model.


Now you understand how to simply restore most of your WordPress set up solely from a backup. You additionally know how you can detect further points, comparable to damaged hyperlinks or lacking photos and an important trick so as to recuperate them when you now not possess these photos. Be sure that to begin making backups of your web site so as to keep away from any points in case your web site will get misplaced or eliminated. Listed here are just a few nice WordPress backup and restoration plugins that can assist you shield your work


Tomas is a senior buyer assist agent at Hostinger. Apart from offering top-notch technical recommendation every day, he likes to create web sites and do numerous coding aspect initiatives.

Leave a Reply

Your email address will not be published. Required fields are marked *