Here is what you suggested: % ulimit unlimited
I don't know what is going on, since I do have files greater than 2 GB, and no problem with them... At the beginning I thought it was a problem in which MySQL couldn't handle large input files, so I spited my original file into two parts. One a little bit less than 2 GB and the other with the rest of the data. Here you can see that I do have files greater than 2GB: % ls -al | grep supfam -rw-r--r-- 1 supfam supfam 2161802937 Apr 13 22:17 supfam01.sql -rw-r--r-- 1 supfam supfam 887476820 Apr 13 21:58 supfam02.sql -rw-r--r-- 1 supfam supfam 3049279757 Apr 13 19:46 supfamORIGINAL.sql So I don't think this is a limit imposed by the filesystem... unless you can guess something different. I could try using the 'raid' support, and see what happens, but still the problem would persist since I will have to have some indexes and as you say that could bring me to the same problem again. Thank you for your help... I am looking forward to get another answer/direction from your side. Anyway, could you please tell me where can I find a "quick guide to raid support in MySQL"? =) Best regards, Cesar -----Original Message----- From: Sean Quinlan [mailto:[EMAIL PROTECTED] Sent: Miércoles, 14 de Abril de 2004 01:35 p.m. To: Dan Nelson Cc: Cesar Bonavides Martinez; [EMAIL PROTECTED] Subject: Re: Problem with 2GB limit. On Wed, 2004-04-14 at 15:20, Dan Nelson wrote: > Now that's interesting. Max_data_length is set to 4gb, but you're > getting an error at 2gb. Could it be a process resource limit? What > does the "ulimit" command return? You can reset that limit with the > "ulimit unlimited" command. IIRC, some filesystems have a 2gb limit for file size. This could be the wall your hitting? I've used mysql's 'raid' support in a couple instances in the past as a simple way get beyond this data limit (wont help with indexes > your filesize limit however). However I'm having trouble getting that working today! -- Sean Quinlan <[EMAIL PROTECTED]> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
