February 25, 2019
February 25, 2019
Making a backup of your website’s files and databases is always a good idea. The more backups you make – the bigger chance you’ll suffer fewer consequences from unpredictable events. Whether you removed some files accidentally by yourself or your WordPress got compromised and your files were corrupted by malware, it may still be possible to restore your WordPress site. In this tutorial, you will learn how to restore WordPress, even if you have only a MySQL database backup.
This method of recovery is only partial and you might not be able to recover everything, however, WordPress stores most settings and data in its database. Thus, you will be able to recover most of your WordPress website only from your database.
Before you begin this guide, you’ll need the following:
First of all, we need to create an empty MySQL database. We will Import our MySQL database backup to it.
IMPORTANT: Write down the MySQL database details: database name, user and password, as you will need them in the next step. Also, write down the Table Prefix. You can see the Table Prefix on the left side of phpMyAdmin.
Since you only have a MySQL database at the moment, the next step should be installing a fresh WordPress instance:
IMPORTANT: If you did not receive this notification, you might need to re-do the whole process. Double-check your Prefix setting.
At this point, your website should have your old posts and pages, settings, custom CSS files, users. However, without your previous themes and plugins, all of this will not appear as it did before:
Now that you’ve regained most of your website, you might still experience issues with it. Most likely, your Permalinks won’t be working as they were and navigating on your website will result in a 404 Page Not Found error.
You can quickly fix your Permalinks by clicking on Settings on your Dashboard and accessing your Permalinks section. Click Save Changes at the bottom, without actually making any changes. This should refresh permalinks and fix them.
Now comes the hard part. Unfortunately, your database did not contain images from your previous website. There is no easy way to fix this issue. You will need to re-upload each and every image that is missing.
To help you find which images specifically are missing, we will be using the Broken Link Checker plugin.
The most unfortunate situation is when you no longer have those images. In this case, the best solution is checking an archived version of your website. Archive.org is a great tool for such cases and it might have a previous, fully working version of your website. You will be able to download the missing images from there:
Now you know how to easily restore most of your WordPress installation only from a backup. You also know how to detect additional issues, such as broken links or missing images and a great trick in order to recover them if you no longer possess those images. Make sure to start making backups of your website in order to avoid any issues if your website gets lost or removed. Here are a few great WordPress backup and restoration plugins to help you protect your work
May 27 2017
Hello, I would like to install the "word press" in my blog, can you tell me how i do it? thank you