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.
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.
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.
One of our server have a boot loop issue and our last option is to change hardware based on recommendation by software vendor.
The issue when changing hardware is the server sometimes cannot boot even using the same hardware specification. We suspect it is something to do with the device UUID because of hardware change.
So to solve the issue we need to boot in rescue environment to repair boot
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
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.