Running out of space for mysql databases on server ?

[eva2000]

My 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 ony partitioned with 250.65MB of space

now i installed vB 2 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 ?

[Freddie Bingham]

Yes you need to move your mysql databases to a partition with more space.

[eva2000]

thanks... i moved it to /usr by this command

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

works now :D

[therock]

Filesystem 1k-blocks Used Available Use% Mounted
/dev/sda1 101107 38494 57392 40% /
/dev/sda6 1011956 898232 62320 94% /usr
/dev/sda7 1011956 829216 131336 86% /var
/dev/sda8 6585960 2140276 4111132 34%


Where should i move it? and can you give me step by step instructions?

It is located @ /usr/local/mysql

Thanks!!

[eva2000]

hmm both your /usr and /var partitions are close to full - ask your host or find out what's taking up that room you might need a larger or 2nd disk ?