10
Apr
2018
BaseZap
Following tutorial helps in exporting or importing MySQL / MariaDB database using terminal commands. 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. Using the following method is a direct interaction with the MySQL server and […]
03
Apr
2018
Deepak
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
Deepak
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
basezap
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 […]
