Introduction Here I will guide you how to migrate existing website from shared hosting to VPS hosting. I will talk about mainly PHP based website, for example, WordPress that has MySQL database for storing the information and runs on Apache web server. But this website may be based on any technology with any database as…

Posted in Unix

How to migrate website from shared hosting to VPS hosting

Introduction This guide will show you how to backup and restore MySQL database using command line tool in VPS server on CentOS 7 and PhpMyAdmin. You need to take backup of your MySQL database on a daily basis to have minimal impact on your web site’s data loss. Similarly for some inconsistent situations you may…

Posted in MySQL

How to Backup and Restore MySQL Database using command line tool and PhpMyAdmin

Introduction This guide will walk you through the installation process of LAMP stack on CentsOS 7 in VPS server. LAMP is an acronym that represents Linux operating system, Apache web server, MySQL database server and PHP scripting language, which is used to build a dynamic web application whose data are stored into MySQL server and…

Posted in Unix

How to install Linux, Apache, MySQL, PHP (LAMP) stack on CentOS 7

Introduction This guide will walk through initial VPS server setup on CentOS 7. When you bought a new VPS hosting then you need to perform some initial configurations such as new user creation, restrict permissions, restrict login etc. for your VPS server. The hosting company send an email with password which is required to login…

Posted in Unix

Initial VPS Server setup on CentOS 7

Introduction In this post I will show you how to login to your Linux Server with SSH key from Windows using PuTTY. PuTTY is an open source software and SSH and telnet client developed for the Windows platform. I will connect to CentOS 7 (Linux) VPS server with SSH key from Windows operating system using PuTTY…

Posted in Unix

How to Login to Linux Server with SSH key from Windows

Introduction This guide will show you how to manually generate SSH key in Windows environment. We will use here Putty to generate private and public SSH keys in Windows. PuTTY is an open source software and SSH and telnet client developed for the Windows platform. When you install the PuTTY client, you also install the…

Posted in Unix

Manually SSH key generation in Windows