So I just discovered a little bug with mysql in general, and which I am finding extra frustrating on the install I have set up on my mac. The short version of the problem is that if you have a whole lot of tables in a database the application “mysqldump” no longer works, producing
Got error: 1016: Can’t open file: ‘./<database>/<table>.frm’ (errno: 24) when using LOCK TABLES
So I followed up on this, and it seems like this is a somewhat known bug. In particular the problem is noted here: http://forums.mysql.com/read.php?28,162893,162893 along with a solution. However for some reason the mac version of mysql is not obeying the open-files-limit param, either when I pass it through the command line of mysqldump (which doesn’t recognize it as a viable option, or when it is set in the config file my.cfg and rebooted. I happen to be runing mysql version 5.0.51a