How you can 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 probability you’ll undergo fewer penalties from unpredictable occasions. Whether or not you eliminated some information by accident by your self or your WordPress obtained compromised and your information had been corrupted by malware, it could nonetheless be doable to revive your WordPress web site. On this tutorial, you’ll discover ways to restore WordPress, even if in case you have solely a MySQL database backup.

This technique of restoration is just partial and also you may not 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

Initially, we have to create an empty MySQL database. We are going to 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 person to it. On this instance, Hostinger management panel gives the power to create MySQL databases with customers assigned to them in a short time, we solely have to fill out the required info. Take a look at this information, if you’re 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 find out how to use phpMyAdmin’s import function might be discovered right here.
    Import Database

IMPORTANT: Write down the MySQL database particulars: database identify, person and password, as you’ll need them within the subsequent step. Additionally, write down the Desk Prefix. You possibly can see the Desk Prefix on the left aspect of phpMyAdmin.

Step 2 – Restoring WordPress

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

  1. Obtain the WordPress set up information from right here.
  2. Add the WordPress information to your internet hosting account. If you’re unsure how to do that, investigate an in depth information on find out how to installation WordPress right here.
  3. Entry your WordPress set up (by accessing your web site along with your browser) and select a language for the WordPress set up. As soon as you choose the language on your web site, 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 finished accurately, on the finish of the set up, you will note a message that WordPress is already put in.
    WordPress Already Installed

IMPORTANT: In the event you didn’t obtain this notification, you would possibly 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 previous 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 it is best to do is re-install your theme. Merely installation the identical theme that you just’ve used as your default one earlier than. Be certain that to take a look at this information as a reminder on find out how to 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 once you entry your plugins menu, you will note a listing of plugins which can be at present lacking.
    Missing Plugins in WordPress

Step 4 – Fixing Permalinks

Now that you just’ve regained most of your web site, you would possibly nonetheless expertise points with it. More than likely, your Permalinks gained’t be working as they had been and navigating in your web site will lead to a 404 Web page Not Discovered error.

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

Fixing Permalinks

Step 5 – Fixing Lacking Pictures

Now comes the arduous half. Sadly, your database didn’t comprise pictures out of your earlier web site. There is no such thing as a simple method to repair this problem. You will want to re-upload every picture that’s lacking.

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

  1. Similar to with most plugins for WordPress, you’ll be able to installation it through the official plugin repository by means 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. Ensure you 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 show you how to decide which pictures are lacking and their earlier location.
    Broken Link List
  3. Now merely reupload the lacking pictures and, if mandatory, replace their hyperlinks.

Essentially the most unlucky state of affairs is once you not have these pictures. On this case, the very best resolution is checking an archived model of your web site. is a superb software for such circumstances and it may need a earlier, absolutely working model of your web site. It is possible for you to to obtain the lacking pictures from there:

  1. Entry On the prime of the web page you will note the “Waybackmachine”. Enter your web site’s URL and hit ENTER key.
  2. If there are any snapshots accessible of your web site, you will note these blue circles round sure dates of the 12 months. Click on on these dates with a purpose to entry a earlier model of your web site.
  3. After that, seek for the precise pictures which can be lacking and obtain them from the archived model.


Now you know the way to simply restore most of your WordPress set up solely from a backup. You additionally know find out how to detect extra points, corresponding to damaged hyperlinks or lacking pictures and an amazing trick with a purpose to recuperate them if you happen to not possess these pictures. Be certain that to begin making backups of your web site with a purpose 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 will help you defend 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 varied coding aspect initiatives.

Leave a Reply

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