cPanel Hosting Stuff

The common error we sometimes come across while updating the web stats manually for a domain is as given below.

Error while running #/scripts/runweblogs can be fix.
————–
DBD::mysql:b do failed: Can’t open file: ’smtp.MYI’. (errno: 145) at /usr/local/cpanel/cpanellogd line 1924.
DBD::mysql::st execute failed: Can’t open file: ’smtp.MYI’. (errno: 145) at /usr/local/cpanel/cpanellogd line 1926.
DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/local/cpanel/cpanellogd line 1927.
DBD::mysql:b do failed: Can’t open file: ’smtp.MYI’. (errno: 145) at /usr/local/cpanel/cpanellogd line 1930.
DBD::mysql:b do failed: Can’t open file: ’smtp.MYI’. (errno: 145) at /usr/local/cpanel/cpanellogd line 1931.
DBD::mysql:b do failed: Can’t open file: ’sends.MYI’. (errno: 145) at /usr/local/cpanel/cpanellogd line 1932.
————–
You need to run following command on shell as a root user and and this should fix the error. But take the backup of the
table you are repairing before running the command.

#myisamchk -r /var/lib/mysql/eximstats/smtp.MYI
#myisamchk -r /var/lib/mysql/eximstats/sends.MYI

If you get any error while running the above command use below options.

–safe-recover (-o), the –force (-f) option or by not using the –quick (-q) flag

Once this is done run
#/scripts/runweblogs <usernmae>

MySQL and databases