Restoring WordPress Site with a Database Backup

Is your WordPress site has been hacked and you want to restore it with a database backup. So you are in the right place, keep reading this guide here we will show you how to take WordPress Backup.

As we all know that, taking complete WordPress Backup on regular basis is a compulsory task if you are running a business online. No matter, backup your site manually or with the help of WordPress Support backup plugins.

Have a look we will see you how to restore the WordPress site with a database backup:

This method of recovery is partial and you may not be able to recover everything, but WordPress saves most data files in settings in your database. Thus, in order to restore the WordPress site, we have to go through the following steps:

1. Importing a WordPress Database Backup
2. 2 – Restore a WordPress
3. Restore your themes and plugins
4. Fix a Permalink
5. Correct the missing images.

Before you start with this guide, you will need the following:

• Access your hosting control panel.
• MySQL Database Backup.

Step 1: – Importing a WordPress Database Backup.

Firstly develop an empty MySQL database. We will import MySQL database backup for it.

• Execute the Hosting Control Panel and find your MySQL database management menu in it.
• Develop a database and assign it a user. In this case, the Hosting Control Panel gives the ability to create MySQL databases with users who allocate them very quickly, we only have to fill the information required.
• Perform your newly created/developed database through PhpMyAdmin. Ignore Wp-config.php in WordPress.
• Lastly, import the database you have stored with your subsequent WordPress installation. You can do this on the import section of the database: Just select the .sql file (1), and set the format of SQL (2) and then press the go button (3). A detailed blog about using the PhpMyAdmin import feature can be viewed here. Intentionally there are some functions of naming function.php in WordPress near php.

Step 2:– Restoring a WordPress.

Since you have only one MySQL database in the same movement, the next step you should have is to install a fresh WordPress for example:

1. Download WordPress installation files from the best sites.
2. Upload the WordPress file to your hosting account. If you do not know how to do this, then see a detailed blog on 4 simple steps to install WordPress.
3. Perform your WordPress installation (proceed with the browser you use through your website) and choose a language for WordPress installation that we recommend only English. After selecting the language for your website, click on Let Go, you will be sent in the database configuration phase. Use the blog information of the database we just created.
4. If done properly, then at the end of the installation you will see a message that WordPress is already installed.

Step 3:– Re-installing your Themes and Plugins.

At the very point, your website should have your old posts and files, settings, custom CSS data. However, your next topic and plugin will not be, all of which will not look the same:

• The first thing you should do is reinstall your theme. Before this, you should know how to install wordpress themes. Now just install the theme that you previously used as your default. Be sure to check out this blog as a reminder about how to easily install WordPress theme.
• Now install your later plugin again. Chances are, your database files should have a list of installing and activation plugins later on, so when you execute your plugins menu, you will see a list of the plugin that is currently missing.

Step 4 – Fix a Permalinks.

Now that you have backed up most of your website, you can still solve problems with it. Similarly, your permalinks are not working yet because they were working on your website before and after, as a result, there will be a 404 page, not error code.

You can quickly fix your permalinks by clicking Settings on your dashboard and executing your Permalinks section. Now, without the actual changes, click Save Changes at the bottom of the window. It should refresh Permalinks and fix them for you.

Step 5 – Fix the Missing Images.

Now reaches the hard part of your blog. Unfortunately, there were no further pictures on the website in your database. However, no easy way to fix this problem you will have to re-upload each & every image that is missing from the content.

To make it easy for you then find out which images are actually missing, we will use the broken link checker plugin.

• Like most plugins for WordPress, you can install it through your WordPress admin area via the official plugin. Simply click on the plugin on your dashboard and select Add new Enter broken links checker in the search bar on your window and install plugins. Check here how to install the wordpress plugin. Be sure to activate your newly installed plugin in your database.
• After this, execute your newly installed plugin by clicking on the tool and accessing the broken link through the dashboard. After this you will see a list of broken links, it will help you to determine which images have gone from your data and their location.
• Now upload the missing images again and, if necessary, update their links. The most opposite situation occurs when you do not have those pictures in your database. In it, the best way is to check a stored/blocked version of your website. Archive.org is a great tool for this kind of case and should have a fully functional version of your website later on. You will now be able to download lost images from there.

That’s All!