{"id":12398,"date":"2009-09-20T11:50:42","date_gmt":"2009-09-20T18:50:42","guid":{"rendered":"http:\/\/www.kith.org\/journals\/jed\/2009\/09\/20\/12398.html"},"modified":"2009-09-20T11:50:42","modified_gmt":"2009-09-20T18:50:42","slug":"cant-find-mysql-in-snow-leopar","status":"publish","type":"post","link":"https:\/\/www.kith.org\/jed\/2009\/09\/20\/cant-find-mysql-in-snow-leopar\/","title":{"rendered":"How to find MySQL in Snow Leopard"},"content":{"rendered":"\n<p>Just discovered that in Mac OS X 10.6 Snow Leopard, the directory \/usr\/local\/mysql no longer exists.<\/p>\n<p>Which means that if you previously ran commands like mysqldump from \/usr\/local\/mysql\/bin, those commands won't work any more. For example, if you have a backup script that uses mysqldump to back up a database, that script breaks under Snow Leopard.<\/p>\n<p>Fortunately, there's an easy-to-implement fix: create \/usr\/local\/mysql as a symlink\/alias pointing to the actual MySQL directory in \/usr\/local.<\/p>\n<p>Planet Geek shows <a href=\"http:\/\/planet-geek.com\/archives\/2009\/09\/osx-snow-leopar.html\">how to create a mysql symlink<\/a>. You'll have to have root access on your machine, of course, and you'll have to plug in your actual mysql directory name at the appropriate place; for example, mine is mysql-standard-5.0.22-osx10.4-i686.<\/p>\n<p>Note that in their writeup, as it appears in my browser window, the final L isn't visible on one of the command lines; it should of course say \"mysql\" rather than \"mysq\".<\/p>\n<p>Also note that at least in some shells, you may have to run <code>rehash<\/code> after setting up the symlink.<\/p>\n\n","protected":false},"excerpt":{"rendered":"<p>Just discovered that in Mac OS X 10.6 Snow Leopard, the directory \/usr\/local\/mysql no longer exists. Which means that if&#8230;<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[83,75],"tags":[],"class_list":["post-12398","post","type-post","status-publish","format-standard","hentry","category-apple","category-databases"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.kith.org\/jed\/wp-json\/wp\/v2\/posts\/12398","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.kith.org\/jed\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.kith.org\/jed\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.kith.org\/jed\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kith.org\/jed\/wp-json\/wp\/v2\/comments?post=12398"}],"version-history":[{"count":0,"href":"https:\/\/www.kith.org\/jed\/wp-json\/wp\/v2\/posts\/12398\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.kith.org\/jed\/wp-json\/wp\/v2\/media?parent=12398"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kith.org\/jed\/wp-json\/wp\/v2\/categories?post=12398"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kith.org\/jed\/wp-json\/wp\/v2\/tags?post=12398"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}