/tmp partition won't increase?
 

Used chirpy's method from cpanel forums

/etc/init.d/chkservd stop
/etc/init.d/mysql stop
umount /var/tmp
umount /tmp
replace "256000" "512000" -- /scripts/securetmp
rm /usr/tmpDSK
/scripts/securetmp --auto
cd /tmp
ln -s /var/lib/mysql/mysql.sock
/etc/init.d/mysql start
/etc/init.d/chkservd start
df

# Add the following line before /scripts/securetmp to /etc/rc.d/rc.local
replace "256000" "512000" -- /scripts/securetmp

Its not increasing in size. I got no errors either. I rebooted before I began and even after. /tmp is only 190MB now. Anyone know what the issue could be? I want /tmp to be about 2GB in size

You need LVM to increase and decrease partition sizes on the fly. And that isn't a function of SQL on any operating system. Partitions will not magically increase or decrease because they are formatted at a certain size. If you already have a 2 GB /tmp partition then you'll be able to allow sql to access it. If your /tmp partition is only 200 MB's, then no. SQL has nothing to do with allocating partition size on your filesystem- at all.