Using dd command create a file of the required size:
Stop MySQL so that it wont create any database problem.dd if=/dev/zero of=/usr/tmpDSK1 bs=1024 count=2048000 --- > 2GB
dd if=/dev/zero of=/usr/tmpDSK1 bs=1024 count=10485760 --- > 10 GB
Execute the below command untill /tmp is completly unmounted./etc/init.d/mysql stop
Rename the orginal /tmp to backupumount /tmp -l
Rename the created tmp to orginal tmpmv /usr/tmpDSK /usr/tmpDSK.bak7
Format the tmp createdmv /usr/tmpDSK1 /usr/tmpDSK
Check fstab and remove or comment out the old /tmpmkfs.ext3 /usr/tmpDSK
Change the tmp permission
Restart MySQLchmod 1777 /tmp
/etc/init.d/mysql restart