{"id":48,"date":"2008-07-11T12:19:37","date_gmt":"2008-07-11T17:19:37","guid":{"rendered":"http:\/\/osric.com\/chris\/accidental-developer\/?p=48"},"modified":"2008-07-11T12:19:40","modified_gmt":"2008-07-11T17:19:40","slug":"very-frustrated-with-mysql-on-the-mac","status":"publish","type":"post","link":"https:\/\/osric.com\/chris\/accidental-developer\/2008\/07\/very-frustrated-with-mysql-on-the-mac\/","title":{"rendered":"Very Frustrated with mysql on the mac"},"content":{"rendered":"<p><img decoding=\"async\" style=\"max-width: 800px;\" src=\"https:\/\/osric.com\/chris\/accidental-developer\/wp-content\/uploads\/2008\/07\/logo-mysql-sun.gif\" align=\"left\" \/> 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 &#8220;mysqldump&#8221; no longer works, producing <\/p>\n<p><small>  Got error: 1016: Can&#8217;t open file: &#8216;.\/&lt;database&gt;\/&lt;table&gt;.frm&#8217; (errno: 24) when using LOCK TABLES<\/small><\/p>\n<p>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&#8217;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<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 &#8220;mysqldump&#8221; no longer works, producing Got &hellip; <a href=\"https:\/\/osric.com\/chris\/accidental-developer\/2008\/07\/very-frustrated-with-mysql-on-the-mac\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Very Frustrated with mysql on the mac<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-48","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/osric.com\/chris\/accidental-developer\/wp-json\/wp\/v2\/posts\/48","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/osric.com\/chris\/accidental-developer\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/osric.com\/chris\/accidental-developer\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/osric.com\/chris\/accidental-developer\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/osric.com\/chris\/accidental-developer\/wp-json\/wp\/v2\/comments?post=48"}],"version-history":[{"count":0,"href":"https:\/\/osric.com\/chris\/accidental-developer\/wp-json\/wp\/v2\/posts\/48\/revisions"}],"wp:attachment":[{"href":"https:\/\/osric.com\/chris\/accidental-developer\/wp-json\/wp\/v2\/media?parent=48"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/osric.com\/chris\/accidental-developer\/wp-json\/wp\/v2\/categories?post=48"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/osric.com\/chris\/accidental-developer\/wp-json\/wp\/v2\/tags?post=48"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}