Hi All,

I am facing problem in mysql databases backup. it gives me error like
below

mysqldump: Couldn't execute 'show fields from `si_biller`': Out of
resources when opening file '/tmp/#sql_535b_0.MYI' (Errcode: 24) (23)

i have added this two line in /etc/security/limits.conf

mysql soft nofile 24000
mysql hard nofile 32000

After this setting Comparably before error coming less but still
there are coming few error as below

mysqldump: Couldn't execute 'SHOW TRIGGERS LIKE 'content\_medicalreview
\_message'': Can't read dir of './contentdata_live/' (errno: 24)
(1018)
mysqldump: Couldn't execute 'SHOW TRIGGERS LIKE 'tbl\_admin'': Can't
read dir of './contestcentral/' (errno: 24) (1018)
mysqldump: Couldn't execute 'show fields from `si_biller`': Out of
resources when opening file '/tmp/#sql_535b_0.MYI' (Errcode: 24) (23)

Please suggest possible solution how to resolve this issue.

Waiting positive response

Best Regards,

Puran Prajapati

M - 9909001951

--
Please read http://www.catb.org/~esr/faqs/smart-questions.html before posting.
You received this message because you are subscribed to the "Vibrant GNU/Linux User Group".
To stop receiving emails from this group, mail to VGLUG+unsubscribe@googlegroups.com
To post to this group, send email to VGLUG@googlegroups.com
For more options, visit this group at http://groups.google.com/group/VGLUG