Blog

Blog

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 […]

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 […]

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 […]