Original URL: http://help.hardhathosting.com/question.php/39
NOTE: This article pertains to accounts created before July 7th, 2003.
Unfortunately, the Sphera VDS software counts your log files as diskspace and therefore, it goes against your quota. However, there is a fix. By default, every MySQL action is logged in a file. This file is located here:
/usr/local/mysql/var/[YOURDOMAIN].logTo resolve this problem, login to your VDS via SSH and change directories by running this command:
cd /usr/local/mysql/var/Then run the command:
ls -lYou will see a file named [YOURDOMAIN].log, replacing [YOURDOMAIN] with your domain name minus the tld. Your can then run the command:
rm [YOURDOMAIN].logThe file should now be removed. You can now run the command:
touch [YOURDOMAIN].logThis will re-create the log file. After this is accomplished, run the command:
vi /etc/my.cnfAbout half way down you will see a line that just has "log". Comment out this line so that it look like this:
#logSave the my.cnf file. Now login to your VDS control panel and restart your VDS. Your Disk Quota should be much less.