Home » Archive

Articles in the articles Category

articles, Headline, Linux tips, Tutorial »

[4 Sep 2019 | 2 Comments | 2,775 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.

articles »

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

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

articles »

[18 Mar 2019 | 4 Comments | 2,299 supporters]
MySQL down because of InnoDB

This method that I use proven as alternate solution to repair MySQL. As we all know if anything problem with InnoDB database corruption the whole MySQL database will down. My method will change the InnoDB database engine to MyISAM or at least reduce the amount of database which is using InnoDB engine.