Hi!
>>>>> "grant" == grant <[EMAIL PROTECTED]> writes: >> Description: grant> when running a "insert data infile" command on a 500MB text file, I grant> get the error "ERROR 1030: Got error 22 from table handler" from grant> mysql. I did a listing of the database files and it looks like this: grant> -rw-rw---- 1 root root 2147397632 Jul 3 09:46 finddata.MYD grant> -rw-rw---- 1 root root 266409984 Jul 3 10:01 finddata.MYI grant> -rw-rw---- 1 root root 8866 Jul 3 08:45 finddata.frm grant> I thought that Solaris 2.6 didn't have a problem with files over 2GB. >> How-To-Repeat: grant> Generate a large database, up to the 2GB limit. It should blow up on you. >> Fix: grant> unknown On Solaris 2.6 it depends on how you create the file system and how MySQL is compiled if you can create files bigger than 2G. You can verify the max file limit supported internally by MySQL by creating a file with MAX_ROWS=100000000 and then do a SHOW TABLE STATUS on the table. If the max data file length > 2G then the limit is on the file system, in which case you probably have to do re-format your disk to get it to support larger files. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
