Blog

Blog

06 Apr
2018
ColorHosting BaseZap

Install WP-CLI | Setup WordPress / Export / Import Database by WP-CLI

In this tutorial we will cover, how to install WP-CLI and use it for WordPress database backup, database import, creating new WordPress instance. How to install WP-CLI  (for all users) Prerequisites Root level SSH access to server PHP 5.3.29 or higher version WP-CLI support wordpress 3.7 or above versions only. To test if your server has […]

03 Apr
2018
ColorHosting BaseZap

Export and Import Database in Linux using Command Line

Following guide helps to export and import database of MySQL / MariaDB using Command-Line. It is very useful when the database size is pretty big and the software like PHPMyAdmin, MySQL workbench might give you timeout issue or take abnormally very high time. The mysqldump client utility performs logical backups, producing a set of SQL […]

13 Mar
2018
ColorHosting zapbase

Setup Virtual Hosts with Apache on Node.js CentOS Server

Hello Zappers, Do you want to host multiple Node.js Websites on the same Server with different location stored? No Problem, we have a solution for you. We will use apache to turn our server into a web server. There are small requirements for this process. Requirements CentOS Machine with ROOT Access Node.js Installed on Server. […]

10 Mar
2018
ColorHosting BaseZap

How to recover or recreate MYI file of a Table in MySQL DB

Hello, Today we will tell you about MyISAM and MYI file and how to recover or recreate MYI file for Table in MySQL Database. MySQL relational database management system prior versions to 5.5 were using MyISAM as a default storage system for databases. MyISAM is old but it has many useful extensions till date. MyISAM table […]

08 Mar
2018
ColorHosting BaseZap

Guide to Install Node.js on CentOS 6/7

Hello, Have a website which needs Node.js to work and have no idea how to install it on your Server? No Problem, this guide will how you how you can install Node.js on your Server with CentOS Machine. Requirements Server with CentOS 6/7 Root Access to Server Procedure Login to Server using SSH Add Node.js […]

08 Mar
2018
ColorHosting BaseZap

Guide for Installing Pure-FTPd and Creating Virtual Users

Hey Zappers, Bored of managing files over WebUI and want some change? So, we have a good choice for a change. We will show how you can install FTP Server on your VPS or Dedicated Machine using Pure-FTPd tool. We will also show you how you can create Virtual Users for FTP Service that can […]

26 Feb
2018
ColorHosting BaseZap

Guide for changing TimeZone of WHM/cPanel Server

Hello, Today we will show you the Guide for changing TimeZone of Server using cPanel / WHM. The steps are very simple to follow, we will include screenshots as well for demonstration. Requirements WHM / cPanel installed on Server with its credentials. Root SSH Access to MySQL Server Procedure Change TimeZone in WHM This will […]

24 Feb
2018
ColorHosting BaseZap

Guide to Backup and Restore Redis Database and Automate

Hello, Today we will show how we can backup and restore Redis database and we will also show how we can automate the process of taking backup. Cronjob will be created for automation of the backup of the database on the machine locally. Requirements Redis-CLI installed on Linux Machine Redis Server Running Root Access to […]

24 Feb
2018
ColorHosting zapbase

How to find actual free RAM available in your Linux system

1. The following command will help you get the details of total ram, ram usage, free available ram. free -m Output: % free total used free shared buffers cached Mem: 2061712 490924 1570788 0 60984 220236 -/+ buffers/cache: 209704 1852008 Swap: 587768 0 587768 The main point to note here is that the “used” memory […]

17 Feb
2018
ColorHosting basezap

Make MySQL Faster by Killing Sleep Connections Automatically

Here’s a Bash script to kill sleeping MySQL connections automatically and almost immediately to decrease MySQL CPU Usage and make MySQL Faster. This tutorial works only if you have a server with root access, and you’re logged in as root. This script uses about 0.25% on a normal VPS with 1vCPU of the CPU with […]

NEED ADDITIONAL HELP? WE'RE HERE FOR YOU.

Our team is available and on-site 24/7 ready to help you.