Re: mysqldump giving errors [SOLVED]
Leant from this post.Thanks. On Sat, Jun 21, 2008 at 9:35 PM, <[EMAIL PROTECTED]> wrote: > I found the bug report at > http://bugs.mysql.com/bug.php?id=26026 > > Adding --lock-all-tables as in > mysqldump --lock-all-tables --no-data etc. > solved the problem. > > > - Original Message - > *From:* Moon's Father <[EMAIL PROTECTED]> > *To:* [EMAIL PROTECTED] > *Cc:* mysql@lists.mysql.com > *Sent:* Saturday, June 21, 2008 12:20 PM > *Subject:* Re: mysqldump giving errors > > Maybe you have to adjust your file limit by user named mysql. > > On Sat, Jun 21, 2008 at 7:50 PM, <[EMAIL PROTECTED]> 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 > > -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
Re: mysqldump giving errors [SOLVED]
I found the bug report at http://bugs.mysql.com/bug.php?id=26026 Adding --lock-all-tables as in mysqldump --lock-all-tables --no-data etc. solved the problem. - Original Message - From: Moon's Father To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Saturday, June 21, 2008 12:20 PM Subject: Re: mysqldump giving errors Maybe you have to adjust your file limit by user named mysql. On Sat, Jun 21, 2008 at 7:50 PM, <[EMAIL PROTECTED]> 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
Re: mysqldump giving errors
Maybe you have to adjust your file limit by user named mysql. On Sat, Jun 21, 2008 at 7:50 PM, <[EMAIL PROTECTED]> 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