My ultraspeedusa/burst.net server is partitioned as

Mount Type Partition Percent Capacity Free Used Size
/ ext2 /dev/sda8 76% 57.93 MB 179.78 MB 250.65 MB
/boot ext2 /dev/sda1 14% 18.77 MB 2.81 MB 22.76 MB
/home ext2 /dev/sda6 32% 2.40 GB 1.12 GB 3.70 GB
/usr ext2 /dev/sda5 43% 2.02 GB 1.49 GB 3.70 GB
/var ext2 /dev/sda7 100% 0.00 KB 237.72 MB 250.65 MB

where /var/lib/mysql is where my databases are. but partition /dev/sda7 is only partitioned with 250.65MB of space.

now i installed vB version 2 beta1 on a separate database for testing and that took up nearly all of /var space in /var/lib/mysql

now my forum doesn't even load at all ?

can i change the mysql database files into /usr something which has 2 gb of free space ?

are all webhost manager powered servers allocated so little to /var on partition /dev/sda7 ?

You could move the mysql folder to the /usr drive then create a symlink to it.

mv mysql /usr
ln -s /usr/mysql /var/lib/mysql

I believe that would do it

thanks Tcoy that worked perfectly :)

another set of commands i have to file away for future reference :D