First off..sorry for placing this post in two forums, but I didn't know how much traffic the *BSD forum got and figured that a Linux pro could answer this question also.

I'm running VBulletin 2.0 on FreeBSD, and a MYSQL database

I've just started getting this error on my forum
mysql error: Can't create/write to file '/var/tmp/SQL115cbe_0.ISM' (Errcode: 28)
mysql error number: 1

which basically means

Error code 28: No space left on device

The partitition containing /var/tmp is out of space.

According to this /var is only 11%

bash-2.03$ df
Filesystem 1K-blocks Used Avail Capacity Mounted on
/dev/da0s1a 127023 56109 60753 48% /
/dev/da0s1e 127023 635 116227 1% /tmp
/dev/da0s1h 7668385 3296288 3758627 47% /usr
/dev/da0s1f 127023 12338 104524 11% /var
/dev/da0s1g 127023 12681 104181 11% /var/mail
/dev/da1a 17370434 5519629 10461171 35% /usr2
procfs 4 4 0 100% /proc

Is it possible to increase a partition in FreeBSD?
What man pages should I be looking at to do this? Or how do I go about fixing this problem since I seem to have plenty of space on my machine!

Thanks in advance

so that'll be THIS thread then...
http://www.linuxquestions.org/questi...threadid=19327
please don't double post. most forums will have equal traffic, as most users simply get new post from all forums at once