Move Live WordPress Site to Localhost ?

A WordPress website may have initially been developed on your local development workstation and publish or you may be taking over the support agreement for a WordPress website and want to carry out some additional work. Either way you don’t want to be developing straight on the Live Server.

 

We’ll explain how you can move your Live WordPress Website to your local software development machine to continue development.

 

The steps to do this are as follow:

 

  • Back up and download your existing website
  • Back up and download the mySQL database
  • Restore Live Database locally
  • Run query to change URL in database
  • Restore live site locally
  • Change Live Site URL in Local URL Tables
  • Put Live site files in loclahost folder
  • Edit wp-config.php
  • Test your website

 

Back up and download your existing website

 

The vast majority of Web Host use CPanel and this will greatly simplify the process of creating a back up of your website.

 

Login into CPanel and navigate to File Manager

 

CPanel File Manager

 

We usually compress the entire public_html folder or whatever directory your WordPress site has been installed in.

 

Depending on the size of your WordPress file, you can either download it straight from the CPanel or you can connect to your FTP and download the compressed folder.

 

Back up and download the mySQL database

 

Login into your Live Websites phpMyAdmin and Export your your Database

mySQl Export

You may need to change a few settings here, depending on your set up.

 

Restore Live Database locally

 

Login in to your local PhpmyAdmin (http://localhost/phpmyadmin) and create a database with the same name as your production.

 

Restore Live Database to locally

Navigate to you Import tab and import the database

Import mySQL Database

 

Change Live Site URL in Local URL Tables

 

Got to the SQL tab in http://localhost/phpmyadmin and execute the following queries putting your website URL

Put Live site files in localhost folder

 

Ensure your local host folder is empty

move your tar file to this folder

uncompress the file

Change persmissions on the folder

Edit wp-config.php

You will need to change the UserName and password for the database in your wp-config.php.  We’ll we’ll use nano tesxt editor to the edit the file.

change your DB_USER and DB_PASSWORD to your local username and password.

Gary Woodfine

Founder & CTO of threenine.co.uk. Experienced full stack software developer well versed in delivering web & mobile applications utilizing cloud architectures. Areas of speciality include cross platform development in .net , PHP, JavaScript.

π
%d bloggers like this: