Home » Archive

Articles in the articles Category

articles, Linux tips, Tutorial »

[19 Sep 2018 | No Comment | 1,561 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 »

[18 Sep 2018 | No Comment | 868 supporters]
Enable EasyApache 3 for new Cpanel

This note is for myself since my server still rely on EasyApache 3. On the new Cpanel WHM58 and WHM60 EasyApache 4 is a default software use to compile Apache,Php and others required component in the server.
EasyApache 3 is scheduled for deprecation in January of 2018, when cPanel & WHM version 62 reaches End of Life. After that time, EasyApache 3 will no longer receive any updates

articles »

[17 Sep 2018 | No Comment | 119 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.