Bash script to backup and restore MySQL, InnoDB database for Cpanel server

[ 4 Sep 2019 | 2 Comments | 2,658 supporters ]
Bash script to backup and restore MySQL, InnoDB database for Cpanel server

If you want to dump a few database the command ‘mysqldump’ is sufficient. How about the server that have several hundred databases inside. It is easier if we create Shell scripts to do the task. There are 2 version of scripts I normally use. One is to backup whole MySQL database, the other is to backup InnoDB database only.
The databases will be dumped in the folder that we created first and dumped as *.sql.

Read the full story »
.

Virtualization »

Howto repair corrupted Virtuozzo container
[ 3 Nov 2019 | No Comment | 74 supporters ]

How to repair corrupted virtuozzo container if the container is broken during virtuozzo migration

Read the full story »

Virtualization »

Fix broken virtuozzo container
[ 29 Oct 2019 | No Comment | 79 supporters ]

On this guide, we will learn how to fix broken virtuozzo container. The server is actually a cloud storage server. The purpose of the cloud storage server function like almost high availability. When the hardware node down, the vps container inside the node will automatically migrate to available active hardware node. In this setup we have 5 hardware node or we also called it Parallels Cloud Server(PCS).

Read the full story »

Cpanel »

Restore database from *.frm for corrupted database
[ 23 Oct 2019 | No Comment | 84 supporters ]

Recently on of my client have problem with the database corruption in Cpanel. The website trowing error related with database. We check our daily MySQL backup and found there is no data in the client MySQL database. To make thing worst our weekly and monthly backup also doesn’t have the database. According to client the last access to the website is in March.

Read the full story »

Cpanel »

Remove Billing And Support Integration CPanel
[ 6 Sep 2019 | No Comment | 394 supporters ]

Sometime for some reason we may need to remove billing and support integration in Cpanel. The purpose of the integration is to easily manage billing and support from CPanel particularly for provider who is using WHMCS as a hosting billing software.

Read the full story »

articles »

New Cpanel licensing structure and the alternative
[ 22 Jul 2019 | No Comment | 318 supporters ]

Early this month Cpanel announcing new pricing structure to customers who are using Cpanel for hosting control panel. Cpanel no longer offer UNLIMITED hosting account per license for VPS and Metal server but the licensing structure will be based on how many account in the server.
There are 4 type of license which is Solo, Admin, Pro and Premier. Cpanel Solo is for single account, Admin for 5 accounts, Pro for 30 accounts while

Read the full story »