Subject: Re: Problems with File descriptors
To: Juan Romero <>
From: Jeremy C. Reed <>
List: netbsd-users
Date: 08/21/2002 13:05:35
On Wed, 21 Aug 2002, Juan Romero wrote:

> 	xtraeme:/home/zug# mysql -u root -p unixbsd < unixbsd.sql
> 	Enter password:
> 	ERROR 1 at line 981: Can't create/write to file
> 	'./unixbsd/gl_userindex.MYD' (Errcode: 23)

Try "ulimit -n 1000" (for Bourne shells) or "limit openfiles 1000" (for
csh type shells) first. (Replace 1000 with some number that works for

> 	xtraeme:/home/zug# sysctl -a|grep kern.maxfiles

For your info, you can use "sysctl kern.maxfiles".

Good luck,

   Jeremy C. Reed