Saturday, January 31, 2015

Updating Webalizer Manually, To update Webalizer stats for a single domain on the Cpanel server

 
cd /home/USER/tmp/webalizer/

/usr/local/cpanel/3rdparty/bin/webalizer /usr/local/apache/domlogs/USER_DOMAIN -n USER_DOMAIN

=============================

Use the following commands to preserving old stats,

Below are set of commands:

cd /home/USER/tmp/
cp -af webalizer webalizer.old
cp -af webalizerftp webalizerftp.old
cd webalizer
/usr/local/cpanel/3rdparty/bin/webalizer /usr/local/apache/domlogs/domainname -n domainname


============================

 

Wednesday, January 21, 2015

MySQL: ERROR 1010 (HY000): Error dropping database (can't rmdir './suhail', errno: 39)

The problem 
==========
mysql> drop database suhail;
ERROR 1010 (HY000): Error dropping database (can't rmdir './suhail', errno: 39)

The solution
==========
# cd /var/lib/mysql 
var/lib/mysql# ls
suhail
/var/lib/mysql# rm -fr suhail
mysql> drop database suhail;
ERROR 1008 (HY000): Can't drop database 'suhail'; database doesn't exist
mysql> create database suhail;
Query OK, 1 row affected (0.00 sec)
mysql> drop database suhail;
Query OK, 0 rows affected (3.38 sec)