How to Restore WordPress Backup Manually

Do you want to restore your WordPress blog manually without using the plugin? WordPress data are stored in root directory and database, you need to make backup of wp-content folder located in root directory and database from phpMyAdmin. In this tutorial you will learn how to restore WordPress backup manually.

You can also keep the WordPress backup using plugins easily but when you are unable to access your WordPress dashboard then you need to backup WordPress blog manually.

Restoring Backup Manually

  1. Install FileZilla to Restore Blog Data

  2. Access phpMyAdmin to Backup Database

Step-1: Install FileZilla to Restore Blog Data

FileZilla is the software that transfers files to the web server or from the web server. FileZilla use File Transfer Protocol to transfer files. There are many other FTP client such as CoreFTP and CyberDuck that allow you to transfers the files. You can Download and install FileZilla from its official site.

The above link will take you to the FileZilla website where you need to click on Download FileZilla Client button. Once downloaded install it into your computer.

After installation, open FileZilla where you have to enter your web server FTP login credential such as host name, username, password and port to connect. If you do not know you web server’s FTP login credential follow the steps below, if you know the login credentials then you can skip this step.

How to Find FTP Login Credentials?

Most of the best website hosting provides you the control panel to manage your website easily. You need to login to the cPanel and click on FTP Accounts under files then click on Configure FTP Client to expand. You will see login details in Manual Settings.

FTP login details

Once you get your FTP account details, open FileZilla and enter the login credentials and click on quick connect button.

Ftp connect to server

There are two sections in FileZilla, PC Section at left and Server Section at right. From the Server Section open root directory e.g. Public_html.

double click to open

Navigate to your WordPress backup destination folder e.g. desktop in your computer from PC section then drag and drop wp-content folder to the Server Section in root directory.

drag wpcontent

The transfer process will start, it will take few hours depending on the file size to complete file transfer. In the middle of the process you will see the message to overwrite the folder. Select Apply to current queue only under Always use this action and click on OK button.

overrite files

Step-2: Access phpMyAdmin to Restore Database

Once wp-content folder transfers successfully you need to restore database file to the web server.

Login to your cPanel e.g. Under Databases Click on phpMyAdmin.


Click on your Database Name from left side of the screen e.g. webmwuhm_AS1. Select Check all/Check tables having overhead and click on Export tab at the top.

From the left side, Click on database name e.g. webmwuhm_AS1. Select Check all/Check tables having overhead. Click Drop from drop down menu.

import database

It will delete existing database table. Click Yes to delete.

yes to drop

Now your database is empty and ready to import. Click Import tab from the top bar. Click Choose file to import your database from your computer. Open you backup folder, select your database webmwuhm_AS1.sql, and click Open. Make sure your database name and backup database file name are same. Click on Go button to import.

importing db

Importing will take few moments, after completion, you will see successful message below.

Database successfully imported

You have completed restoring WordPress backup successfully. We hope that this guide is helpful to you. You may also like to take a glance on Two ways to Optimize your Blog Performance using Plugins please share and follow us on Facebook and let us know your opinion in the comment section below.

You may also like...

Leave a Reply

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