I have a Cpanel server with 2 80GB drives. My /tmp partition is as follows:
/dev/sda6 1012M 33M 928M 4% /tmp

I need to increase the size of the /tmp partition, probably to 2 to 4 GB. I have a huge database and I am trying to create a full-text index on several fields and I keep getting a warning that I'm out of space in the /tmp directory. The only thing I use this server for is to manage the huge database.

How do I increase the /tmp partition? Can I move it to the backup drive? Can I make mysql use another directory for the temporary files?

Any help would be greatly appreciated.

I'm not familiar with partitioning but I'm great with vi

Look at my how-to in my signature. When you create the mountpoint in /dev/ just make it have more blocks. The guide already shows you how to first copy the data.

Super, thanks.

I also found that you can modify the mysql startup to use any directory for the temp directory. I used a directory on my backup drive instead.

However, I'm going to use your list to harden my server.

Thanks.

This is what finally worked for me http://forums.holly-ridge.com/showthread.p...hp?s=&postid=19

The only thing in this HOWTO I had to alter was the path to mysql.sock. For cPanel, it should be /var/lib/mysql/mysql.sock.

Hi

I created a 190 MB tmp partition before (by eth00 instruction).now I want to increase it to 900 MB .

How can i do this ?

Regard

The new guide has it set at 800, when you do the dd command just change the lbock number from 8000000 to 900000.

Hi

for increase my tmp partition I run this command only :

cd /dev/; dd if=/dev/zero of=tmpMnt bs=1024 count=900000

and then restart the server ??

I think I did a mistake !! Mysql donot start !!!
I havnot access to /tmpMnt !!!
Please help !!