From: Date: June 21 2008 1:20pm
Subject: Re: mysqldump giving errors
List-Archive: http://lists.mysql.com/mysql/213424
Message-Id: <69069d7d0806210420n266b8c28p866dfeb4a1e430da@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; 
	boundary="----=_Part_11968_14314627.1214047233828"

------=_Part_11968_14314627.1214047233828
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Maybe you have to adjust your file limit by user named mysql.

On Sat, Jun 21, 2008 at 7:50 PM, <cr.vegelin@stripped> wrote:

> Hi All,
>
> I am running mysqldump with --no-data option, but it gives error:
> "can't exec 'show fields from ...' out of resources when opening file ...
> (errorcode 24) (23)"
> perror 24 says: too many open files
> perror 23 says: too many open files in system
> mySQL show variables says: open_files_limit: 622
> and the error occurs at the 74th table.
> I have enough GB free space.
> Is this error caused by my Windows or by MySQL ?
> Any suggestions how to solve this ?
>
> TIA, Cor




-- 
I'm a MySQL DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn

------=_Part_11968_14314627.1214047233828--