Running out of space for MySQL dbs - move them to diff. drive?
Hi all,
We have a dedicated Fedora 7 server with Apache and mysql installed on it, and we are running a forum and a couple of blogs on it. We have recently noticed that we are running out of space on drive #3 which holds mysql databases, but have plenty of space on drive #4. It's like this:
Drive sda2 has 750 megabytes free, but this is OK, protected directories only Drive sda1 is similar, small protected directories
Drive sda3 is the problem. 90% of it is full (drive is about 23.7 Gb large), and it holds mySQL databases /var/lib/mysql /var/qmail/mailnames /var/named/run-root
Our forum's database is getting quite large, and we have to do something about this. It is the biggest database on that drive, close to 10 gigabytes.
On the other hand, drive sda 6 has almost 180 gigabytes completely free, and uses only home/httpd/vhosts
which holds mostly web content files, but will never use anything near 180 gigabytes, in fact, web content will hardly go over 2 gigabytes, which means that most of the 180 free gigabytes would be free.
Seeing that we have a big problem with our mySQL databases, could you offer us some advice on what is the best course of action to free up some space for mySQL databases and/or move mysql databases to this new drive?