UsingWW: wwmysqldump error

WeBWorK Main Forum

wwmysqldump error

This forum has a limit to the number of forum postings you can make in a given time period - this is currently set at 10 posting(s) in 1 day

I was trying to following "Backup and Disaster Recovery" and have wwmysqldump created. When I run wwmysqldump, it gives the following error message:

mysqldump: Got error: 23: Out of resources when opening file './webwork/MATH_5504_201930_past_answer.MYD' (Errcode: 24 - Too many open files) when using LOCK TABLES

People from the internet suggested increasing open_file_limit but I wasn't able to change that. Any help will be appreciated.

Re: wwmysqldump error

by Danny Glin - Monday, 23 August 2021, 5:20 PM

I solved this by increasing the open_file_limit as suggested by the internet. Is there a reason that you were unable to change that?

Re: wwmysqldump error

by Joseph Lo - Tuesday, 24 August 2021, 1:42 AM

Thanks very much for the reply. Perhaps I did something wrong last time but it seems to work now by following this page:

https://ixnfo.com/en/how-to-change-open_files_limit-in-mysql.html