/var is filling up, how to change size ?

[odoisc]

A few things from my Server information page :

Filesystem Size Used Avail Capacity Mounted on
/dev/ad0s1a 989M 78M 832M 9% /
devfs 1.0K 1.0K 0B 100% /dev
/dev/ad0s1g 45G 456M 41G 1% /home
/dev/ad0s1f 989M 2.0K 910M 0% /tmp
/dev/ad0s1d 3.9G 1.0G 2.6G 28% /usr
/dev/ad0s1e 3.9G 2.1G 1.5G 59% /var
procfs 4.0K 4.0K 0B 100% /proc

WHM 9.2.0 cPanel 9.2.0-R27
FreeBSD 5.1-RELEASE - WHM X v2.1.2

that /var mount seems to have a limit of 3.9G , and it is already filled for 2.1G . This is mainly because of a big mysql database of the only site on this server. Its a experimental webcrawler/ search engine, and I estimated that I might need about 40G for this. But the problem is that I only have 1.5G left.

Now ofcourse my question is : How can I solve this ? Can I adjust those limits, and decrease /home for 40G and use it to increase /var ? And how should I do that ?

Thanks in advance

 

[bjarne]

MAybe just symlink the database and move the database to /home, make sure mysql can read from it.

 

[kris1351]

You might want to make sure your logs are rotating in /var/log. The link suggestion above is really setting yourself up for a failure. Since all partitions are assigned and no free space was left at the end of the disk you cannot grow the file system. Check logrotate and make sure that is running properly will help also.