How to Upgrade Mysql in WHM/Cpanel

How to Upgrade Your MySQL Migrating from MySQL 5.5 to a newer version is a major upgrade that must be done with some consideration in mind. Returning to MySQL 5.5, in case anything goes wrong, is not possible, so a solid backup is essential before you can proceed with the upgrade. For better stability, we … Read more

How To Disable The IPv6 on CentOS 6 with cPanel

IPv6 has been enabled on CentOS 6 by default & if this causes problem to emails on a cPanel server, following steps can be used to disable IPv6 on a CentOS 6 cPanel server. 1) In WHM >> Exim Configuration Manager got to advance editor and add following line & save the changes: disable_ipv6=true 2) … Read more

Install PowerDNS In CPanel

To install PowerDNS via WHM’s Nameserver Selection interface (WHM >> Home >> Service Configuration >> Nameserver Selection), perform the following steps: Navigate to WHM’s Nameserver Selection interface (WHM >> Home >> Service Configuration >> Nameserver Selection). Select PowerDNS. Click Save. Related Posts:The following cPanel service generated warnings from…How to Upgrade Mysql in WHM/CpanelHow To Disable … Read more

Command Exim Log

Berikut perintah-perintah darurat exim Melihat antrian/queueexim -bpDengan perintah ini kita dapat melihat email-email apa saja yang sedang dalam antrain. Perhatikan pola dan message idnya  Melihat antrian dalam bentuk summaryexim -bp | exiqsumm  Melihat header messageexim -Mvh  idmessageDari sini kita bisa menentukan apa masalahnya, apakah email marketing ataukah karena aktivitas virus Melihat header message dari logroot@server … Read more

Error: The system failed to execute the database script with the following errors: ERROR 1118 (42000) at line 232: Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.

Solusi : nano /etc/my.cnf add this line innodb_file_per_table=1 max_allowed_packet = 1G innodb_log_file_size = 2G innodb_log_buffer_size = 512M innodb_strict_mode = 0 restart servie mysql Related Posts:The following cPanel service generated warnings from…How to Upgrade Mysql in WHM/CpanelMonitoring Server,router dan switch dengan Netwach…Ntpd error while loading shared libraries pada centos 7Cara Setting Port SSH di Centos 8Cara … Read more