How to deploy WordPress website manually from local server to live site

Building your WordPress website on a local server is a safe way to test changes on your website without affecting visitors. When you’re finished perfecting your website, the next step is to move from your local server to a live site. Let’s show you two ways to move your site from a local server to a live site or you can use this for backup purposes also. The first method uses a WordPress migration plugin and is recommended for beginners. In the second method, we will show you how to manually move WordPress from a local server to a live site. You can choose the method that works best for you:

• Method 1: Move the WordPress website from the local server to the live site using a plugin
• Method 2: Manually WordPress website file transfer from the local server to the live site

Method 2: Manually WordPress website file transfer from the local server to the live site

1. Domain added in your host(Cpanel)
   The first step that you should do is you have to add the domain in your Cpanel
   
   here you just click on the domain if you have an unlimited domain add hosting features
   
   
   just create a new domain here 
   
   
   you can add a domain name only, should not include https://  or a URL. 
   
   
2. Create MySQL Database
   
   just click MySQL® Database Wizard and you will see the interface of create the database user
   
   
   Keep a copy of the password of the database user in a safe place and always use the password generator
   
   
   
   
   
   
   
3. Open file manager
   
   
   you can find the actual path from the document’s root folder.
   
   
   
   
   
4. Upload the file to your project folder
   
   
   upload here, you can drop and down the zip file of your project like in xampp, htdocs and you_project_folder_name that you use to open a website like localhost/ggn. Here ggn means project name and folder name in xampp. Similarly other systems you can see inside the www or HTML folder
   
   
   
   confirm that your file uploaded is 100% or not and must be progress bar should be green colour.
   then click on go back to you_hosting_url
   
   
5. Extract the zip file in your project folder of live hosting
   
   
   
   you will get these files in the project folder
   
   
   
6. Edit wp-config.php file 
   
   
   
   
7. Now upload the SQL file in PHPMyAdmin and select your database name click on it 

 

Change the Site URL

Under the field options_name, you need to look for siteurl. Click the Edit Field icon which can be found at the far left at the beginning of the row.

 

Edit site URL and home  like http://localhost/gnn form https://ggn.refreshenpal.com

Then save or go

here is a simple SQL query that should solve this problem:

UPDATE wp_posts SET post_content = REPLACE(post_content, ‘https://localhost/ggn’, ‘http://ggn.refreshnepal.com’);