Latest Tech and Tips

How to Restore a WordPress Site with Just a Database Backup


We all the time advocate our customers to make full WordPress backups on a common foundation. But what in case you unknowingly used one of many free plugins that solely make database backups? In this text, we are going to present you ways to restore a WordPress website with simply a database backup. It won’t be a full restore, however we are going to present you how one can decrease the injury.

Recovering a WordPress site from a database backup alone

Getting Started

For the sake of this tutorial, we’re assuming that you’ve got your WordPress database backup in a zip file. If you wouldn’t have one but, right here is how to make a WordPress database backup manually.

If you’re recovering from a unhealthy expertise with your hosting supplier, then it’s most likely the time to discover a higher host. We have hand picked a number of the greatest WordPress internet hosting suppliers. These are the businesses that we now have labored with and belief with our personal tasks.

Also see: 7 Key Indicators when you must change your WordPress internet hosting.

Preparing to Restore WordPress Database Backup

First, you will want to create a new database. Simply login to your cPanel account and click on on MySQL Databases beneath the Database part.

MySQL databases in cPanel

Next, present a identify in your database after which click on on create database button.

Creating new MySQL database

Now that you’ve got created a database, you want a MySQL consumer who will likely be assigned all privileges to work in your newly created database.

On the identical MySQL databases web page, scroll down to MySQL customers part and add a new consumer.

Adding a new MySQL user

Provide a username and a robust password in your database consumer after which click on on create consumer button.

Next, you want to add this consumer to the MySQL database. Scroll down to ‘Add user to database’ part and choose the consumer alongside with the database from the drop down menus after which click on on the add button.

Adding a user to database

Your new database is now prepared for WordPress.

Importing WordPress Database Backup

First you want to go to the cPanel dashbaord. Under the databases part, you want to click on on phpMyAdmin.

Launching phpMyAdmin from cPanel

On then subsequent step, choose the database you created earlier on the phpMyAdmin web page after which click on on the Import button.

Now you want to click on on the select file button to add your WordPress database backup file. Simply click on on the go button on the backside of the web page to begin importing.


You will see a success message when the import job is completed.

You have efficiently imported your WordPress database. Now the following step is to set up WordPress utilizing your new database.

Restoring Your WordPress Site

For a handbook restore of WordPress, you will want to manually set up WordPress in your server. Visit our step-by-step WordPress set up tutorial and bounce to the part ‘how to install WordPress using FTP’ for detailed directions.

During the set up, if you attain ‘create a configuration file’ step. Enter the database identify and consumer you created earlier.

Creating configuration file step during WordPress installation

You will now see a message that WordPress can join to your database, and you’ll run the set up now.

Clicking on the set up button will now present you the ‘Already Installed’ message.

Already installed message

That’s all now you can proceed to login to your WordPress website.

Restoration Troubleshooting

Since you wouldn’t have your previous WordPress information, there will likely be a number of issues lacking. Some of them could be simply restored whereas others will likely be a bit troublesome. We will undergo all of them one after the other.

1. Theme

Simply set up a contemporary copy of your previous WordPress theme. If you made direct modifications to your theme information, then all these modifications will likely be gone.

You may have to undergo theme choices to set it up the best way it was earlier than.

2. Widgets

Widgets play an necessary position in WordPress themes. Luckily, they’re saved in your WordPress database and switching to your previous theme will restore a few of your widgets.

You can all the time go to Appearance » Widgets to add and rearrange widgets in your sidebars.

Some WordPress plugins come with their very own widgets. In order to use these widgets, you’ll first want to set up and activate these plugins.

3. Permalinks

Your website’s permalink construction can be saved in database, and will probably be routinely restored. However, in case you are seeing 404 errors on front-end of your website, then you definitely want to refresh permalink settings.

Simply go to Settings » Permalinks and click on on the save modifications button with out altering something. This will refresh your WordPress url construction.

4. Plugins

WordPress shops a file of your website’s energetic plugins. When you go to the plugins web page for the primary time, WordPress will present you a record of errors for every plugin that was within the database however is just not put in anymore.

Deactivated plugins

Copy all of the plugin names and begin putting in and activating them one after the other.

Recovering Lost Images in your WordPress Site

Finding and changing misplaced photographs in your web site could be the trickiest a part of the restoration. Depending on how a lot content material and pictures you’ve gotten, this will take a very long time.

Unfortunately, there is no such thing as a simple method round it. You may have to use a number of instruments to extract your photographs from completely different sources. Your possibilities of recovering all photographs are pretty low.

1. Look in Your Browser Caches

If you’ve gotten just lately misplaced your web site, then you’ll be able to look into your browser cache.

Firefox customers can obtain CacheViewer2 add-on to simply discover photographs from their web site saved in browser cache.

Finding cached images in Firefox

You can good click on on a picture and choose save as from the menu.

Google Chrome customers on Windows can strive Chrome Cache Viewer.

Google Chrome customers on Mac will likely be out of luck. We have been unable to discover any cheap answer to browse, preview, and save picture from Google Chrome cache on Mac.

2. Look for Your Images in Web Caches

There are a number of internet providers that maintain cached variations of internet sites. You can begin by on the lookout for your photographs in Google’s picture search. Simply enter your website’s URL and it is possible for you to to see photographs Google discovered in your web site.

Finding your images in Google Image search

You can click on on a picture to see a bigger preview and save the picture.

If you’re restoring a a lot older website and might’t discover photographs on Google or Bing, then you’ll be able to strive It is a non-profit group that shops snapshots of internet sites for historic functions.

Internet Archive Way Back Machine

Finding and Replacing Images on Your Website

If you didn’t have a lot content material in your previous website, then you’ll be able to manually change photographs in your posts. However, when you’ve got a lot of content material then discovering and changing photographs manually will likely be troublesome.

Here is how one can simply find damaged photographs and change them.

First, you want to set up and activate the Broken Link Checker plugin. Upon activation, merely go to Tools » Broken Links Checker web page. The plugin will present you a record of all damaged hyperlinks in your website.

Find and replace missing images in WordPress

Broken photographs are additionally thought of damaged hyperlinks, so they are going to seem within the record as properly. You can click on on the hyperlink textual content column to kind the damaged hyperlinks record to present photographs first.

Now you’ll be able to change the photographs that you’ve got recovered by enhancing posts. For the photographs that you weren’t in a position to get better, you’ll be able to both strive to recreate them or just unlink them.

Bonus Tip

It will likely be onerous to get better all of your misplaced knowledge. Your website could even present errors and have an effect on consumer expertise. This is why you see many consultants strongly urging you to arrange automated backups.

We advocate utilizing BackupBuddy. It is a premium WordPress backup plugin with simple restore choices and the flexibility to routinely create and save your backups on the cloud.

That’s all, we hope this text helped you restore your WordPress website from database backup. You may need to see our record of 13 very important suggestions and hacks to shield your WordPress admin space.

If you preferred this text, then please subscribe to our YouTube Channel for WordPress video tutorials. You may discover us on Twitter and Facebook.