have_query_cache=1
query_cache_size=200M
skip-name-resolve

Bulk Nameservers update in cPanel:

Step 1, do backup:

cp -rf /var/named{,.backup}

Step 2, update NS:

oldns="ns1.old.domain"; newns="ns1.new.domain" ; find /var/named/*.db -exec perl -pi -e "s/(?<=IN\s\NS\s)$oldns/$newns/g" '{}' \;
oldns="ns2.old.domain"; newns="ns2.new.domain" ; find /var/named/*.db -exec perl -pi -e "s/(?<=IN\s\NS\s)$oldns/$newns/g" '{}' \;

Step 3, new serial records:

find /var/named/*.db -mtime -1 -exec perl -pi -e 'if (/^\s+(\d{10})\s+;\s?(?i)serial/i) { my $i = $1+1; s/$1/$i/;}' '{}' \;

Step 4, restart DNS service:

/scripts/restartsrv_named

Original post is here

We can fix the issue ERROR 1273 (HY000) at line someline_here: Unknown collation: ‘utf8mb4_0900_ai_ci’ on the following way:

perl -p -i -e 's/utf8mb4_0900_ai_ci/utf8mb4_general_ci/g' db_dump.sql

Pls do a dump backup before process