On Sat, Feb 02, 2002 at 08:23:49AM -0700, Randy Arabie wrote: > Environment: AlphaStation 255 w/ 64 MB RAM > NetBSD 1.5.2 - custom kernel > MySQL 3.23.47 > > I'm trying to load data into tables in a mysql database. When I feed the > load script into the database it fails about 3/4 through. Error follows: > > <SNIP> > ERROR 1105 at line 11: File ./geeklog/userinfo.MYD not found (Errcode: 23) > </SNIP>
23 is "Too many open files in system" Maybe the whole system has too many open files ? The limit is kern.maxfiles and you can count them with 'fstat'. You may also want to ktrace mysqld while trying to load the database to get more details. -- Manuel Bouyer <[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
