[Bio-linux] Re: Disk space on genomics

[Kerr Wall]

On 11/18/02 4:53 AM, "Milo Thurston" <mith at ceh.ac.uk> wrote:

> In message <B9FBEE7B.7498%pkerrwall at psu.edu> you wrote:
>> Can we move /var/lib/mysql to another partition that is larger?
> 
> Yes. Do the following (as root, or using sudo):
> 
> mkdir /home/db/mysql
> cd /var/lib/mysql
> tar cfp - . | (cd /home/db/mysql; tar xvf -)
> vi /etc/my.cnf
> 
> Now, edit the entry for "datadir" so that it points to
> /home/db/mysql
> 
> /sbin/service mysqld restart
> rm -rf /var/lib/mysql # optional!
> 
Can you do this on genomics so that I don't have to move all of my work
immediately.  

Here is the output from df:
Filesystem           1k-blocks      Used Available Use% Mounted on
/dev/hda6              4032092    226328   3600940   6% /
/dev/hda1                23302     16615      5484  76% /boot
/dev/hda7              1011928    945476     15048  99% /var
none                    515332         0    515332   0% /dev/shm
/dev/hda12            26794328   3530464  21902760  14% /usr
/dev/hdb1             65520588  27725284  34467040  45% /usr/db
/dev/hdb2             10080520    576292   8992160   7% /usr/local
/dev/hdd1             80632188  31552712  44983472  42% /home
/dev/hdd2             34746432  32211524    769876  98%
/usr/local/systemimager
/dev/hda5              6048320    318468   5422612   6% /usr/software

I can't add anything to mysql right now since /var is full.

Kerr

On 11/18/02 4:53 AM, "Milo Thurston" <mith at ceh.ac.uk> wrote:

> In message <B9FBEE7B.7498%pkerrwall at psu.edu> you wrote:
>> Can we move /var/lib/mysql to another partition that is larger?
> 
> Yes. Do the following (as root, or using sudo):
> 
> mkdir /home/db/mysql
> cd /var/lib/mysql
> tar cfp - . | (cd /home/db/mysql; tar xvf -)
> vi /etc/my.cnf
> 
> Now, edit the entry for "datadir" so that it points to
> /home/db/mysql
> 
> /sbin/service mysqld restart
> rm -rf /var/lib/mysql # optional!
> 
> That should get everything working in the way that you want.
> 'bye,
> Milo.
> 
> --
> Dr. Milo Thurston, CEH Oxford, Mansfield Road, Oxford, OX1 3SR.
> 'phone 01865 281658,  fax 01865 281696.
> http://www.bioinf.ceh.ac.uk/lab/
>