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

su-2.03# fdisk
******* Working on device /dev/rda0 *******
parameters extracted from in-core disklabel are:
cylinders=3341 heads=149 sectors/track=36 (5364 blks/cyl)

Figures below won't work with BIOS for partitions not in cyl 1
parameters to be used for BIOS calculations are:
cylinders=3341 heads=149 sectors/track=36 (5364 blks/cyl)

Media sector size is 512
Warning: BIOS sector numbering starts with sector 1
Information from DOS bootblock is:
The data for partition 1 is:
sysid 165,(FreeBSD/NetBSD/386BSD)
start 0, size 17921835 (8750 Meg), flag 80 (active)
beg: cyl 0/ sector 1/ head 0;
end: cyl 1023/ sector 36/ head 148
The data for partition 2 is:
<UNUSED>
The data for partition 3 is:
<UNUSED>
The data for partition 4 is:
<UNUSED>

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

Hi,
here what you could do if /var was your last partition on the slice : man growfs
But it seems that there are two other partitions after it (/var/mail and /usr) . In that case, the only thing you can do, in my opinion, is backing up /var/mail and /usr (with dump for example), deleting them, growing /var (see man growfs) then relabel to recreate /usr and /var/mail. Finally restore /usr and /var/mail.
I forgot something :
if /var is not contiguous with /var/mail then you can grow it to the remaining space.

Hope it helps

Another idea came to me :
Why don't you create a /var/tmp in another partition ?
And why not on the other disk ?
Your first disk is completely dedicated to FreeBee but is there any room free on your second disk ?

The second drive is pretty much clean. I could do what you suggest. What should I be looking at to do this?

If I create a partition for /var/tmp on the second drive will it replace the /var/tmp on the first?

Thanks for the replies.

creating a new partition will replace the old directory all the time it is mounted. the data is not deleted, but is inaccessible. if you were to unmount the partition the old contents would reappear.

To do:
use disklabel in single user mode (boot -s at the boot prompt). Try disklabel -e /dev/da1. Add a new line like da1b (not da1c which represents the whole slice). Make a newfs on it then edit your fstab to add /dev/da1b /var/tmp. Type ^D to enter multi user mode, everything should be ok.

Don't forget to read :
man disklabel
man newfs
man fstab