Restoring word press site into AWS EC2 instance – Legendshub Blog

Today we will discuss about restoring word press website backup step by step.

Existing Landscape: WordPress website is running on Go daddy.

Steps to Restore:

1.) Mostly backup policy depends on rate of content change for the website. Generally speaking it is good practice to have one weekly full backup. In our case we will configure free backup plugin for full backup and redirect backup copy to drop box.

I will have backup placed as a zip in drop box. The good thing with drop box is that it provide user with shareable link which can be unzipped manually on destination instance or can be scripted as well.

Plugin being used for Backup

2.) Now we will configure AWS instance with lamp role configured on it. We will go with T2 medium type of instance .We will login and install httpd, php and Maria dB.

To know more about installing the EC2 instance in AWS look into the following video. We will be configuring AWS Amazon Linux.


To install httpd in linux use the following commands.

yum update
yum install httpd 
yum install httpd

Configure Mariadb repo.

vi /etc/yum.repos.d/MariaDB10.repo [mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.0/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1 yum repolist all yum install MariaDB-server MariaDB-client yum repolist all
yum install MariaDB-server MariaDB-client

Now we will do the secure installation of the database to remove anynomyms access and remote root login by using following command.

mysql_secure_installation

Now as we are using amazon linux we will installing php using amazon-linux-extras command

amazon-linux-extras install -y lamp-mariadb10.2-php7.2 php7.2

3.) We have configured the Lamp role.  Now we will install WordPress on the instance. First all of we will install the version of word press our website was using. My version was latest hence i ma downloading the latest version.

wget https://wordpress.org/latest.tar.gz 
tar -xvf latest.tar.gz

All content after untar will be in word press folder

cd wordpress/

4.) We will download the latest backup from the drop box shareable link. Then we will unzip in the WordPress folder.

After we need to sync the word press folder under /var/www/html

rsync -avP ~/wordpress/ /var/www/html/

5.) We need to restore the SQL backup file by importing it into Maria Db. Before doing it we need to create the new database my login into the mysql using below mentioned commands.

sudo mysql -u root
create database database-name;
grant all privileges on database-name.* to database-username@localhost identified by 'user-password';
flush privileges;
exit;

Once we have database created we need to import the bckyp *.sql in the downloaded zip using below command

mysql -u wpuser -p wpdb < i3349482_wp1.sql

6.) In order to avoid conflicts with redirection we will be adding following lines into the wp-config.php files. Dont forgot to edit the new database, user and password name in wp-config.php

define('WP_SITEURL', 'http://newdomain');
define('WP_HOME', 'http://newdomain');
WordPress Restore

To see it performed practically step by step checkout the video below.


Amrit Pal singh

Designing critical migration from legacy to cloud environments, extending devops approach into analytics, AI/ML to maximize the purpose of agile approach. We work to integrate compliance with risk, security and regulations, building seamless interfaces across multiple systems. I am fortunate to manage complex hierarchy of global portfolios, programs and projects and executive communication . Provide TCO analyses to low level architecture, design and implementation, readiness and building BCP/DR/HA, and around the clock monitoring & management using cloud tools relevant to our customer's situation and objectives.

Leave a Reply

Your email address will not be published.