I tried checking for error codes in the documentation, but didn't find anything particularly useful.
I'm getting this: mysql> load data infile '/export/home/Scratch/WordIndex.txt' into table wordindex (aid, wid, wordform, start, length); ERROR 1030: Got error 28 from table handler In case it helps: mysql> describe wordindex; +----------+-----------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+-----------------------+------+-----+---------+-------+ | aid | smallint(5) unsigned | | | 0 | | | wid | smallint(5) unsigned | | | 0 | | | wordform | varchar(200) | | | | | | start | mediumint(8) unsigned | | | 0 | | | length | smallint(6) | | | 0 | | +----------+-----------------------+------+-----+---------+-------+ 5 rows in set (0.00 sec) and [11:59am] tittle@stephanus> head /export/home/Scratch/WordIndex.txt 1 1 A)RXO/MENOS 26 11 1 1 SE/O 39 3 1 1 FOI=BE 44 6 1 1 PALAIGENE/WN 52 11 1 1 KLE/A 65 4 1 1 FWTW=N 71 5 [11:59am] tittle@stephanus> ls -l !$ ls -l /export/home/Scratch/WordIndex.txt -rw-r--r-- 1 tittle staff 1792422460 Nov 23 15:09 /export/home/Scratch/WordIndex.txt The file *is* huge, but this same file has worked on another installation we have here (I'm migrating part of this over to a new machine), so I don't think the file format is at fault, nor the table construction. So I'm wondering if it's somethign like a memory problem, perhaps due to how I've configured the mysql installation here (or to the installation of the new machine [sun ultra 450] I'm migrating to, tho that's supposed to have oodles more -- the *reason* for moving in the first place...). Tips, pointers, suggestions...all welcomed. Thanks, --Cindy -- [EMAIL PROTECTED] --------------------------------------------------------------------- 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
