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.

Follow Me

Gary Woodfine

Helps businesses by improving their technical proficiencies and eliminating waste from the software development pipelines.

A unique background as business owner, marketing, software development and business development ensures that he can offer the optimum business consultancy services across a wide spectrum of business challenges.
Follow Me

Latest posts by Gary Woodfine (see all)

π
%d bloggers like this: