ulimit problem

[J S]

Hi,
I've run myisampack to compress a table and am now trying to recreate the 
index using myisamchk (as root) but I get an error 27.

# myisamchk -rq --sort-index --analyze --tmpdir=/proxydb/mysql/tmp 
internet_usage.MYI
- check record delete-chain
- recovering (with sort) MyISAM-table 'internet_usage.MYI'
Data records: 30972875
- Fixing index 1
myisamchk: Error writing file '/proxydb/mysql/tmp/ST3hTDMa' (Errcode: 27)
myisamchk: error: 27 when fixing table
MyISAM-table 'internet_usage.MYI' is not fixed because of errors
Try fixing it by using the --safe-recover (-o), the --force (-f) option or 
by not using the --quick (-q) flag
# perror 27
Error code  27:  A file cannot be larger than the value set by ulimit.

The ulimits are set as follows:
default:
       fsize = 2097151
       core = 2097151
       cpu = -1
       data = 262144
       rss = 65536
       stack = 65536
       nofiles = 2000
root:
       fsize = -1
       core = -1
       cpu = -1
       data = -1
       rss = -1
       stack = -1
       nofiles = 4000
When I run myisamchk, is it running with root privilidges or as user mysql? 
By the way this is a large enabled filesystem.

Thanks,
JS.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]