{"id":664,"date":"2011-12-05T08:33:23","date_gmt":"2011-12-05T01:33:23","guid":{"rendered":"http:\/\/oktobrima.staff.fe.uns.ac.id\/?p=664"},"modified":"2011-12-05T08:33:23","modified_gmt":"2011-12-05T01:33:23","slug":"memindah-directory-default-mysql-di-freebsd","status":"publish","type":"post","link":"https:\/\/angga.feb.uns.ac.id\/?p=664","title":{"rendered":"Memindah Directory Default Mysql di Freebsd"},"content":{"rendered":"<p>Secara default, jika kita install mysql server via port maka data-data dari database yang ada dalam mysql server akan tersimpan pada dir \/var\/db\/mysql<br \/>\nAkan merepotkan kalau ternyata partisi \/var kita terlalu kecil, sehingga data nambah sedikit aja partisi \/var udah penuh.<br \/>\nAda 2 cara untuk mensiasati hal tsb,<br \/>\npertama ada merubah letak data directory pada file konfigurasi mysql kita my.cnf.<br \/>\nHal ini memerlukan perubahan pada file konfigurasi my.cnf<br \/>\n# ee \/var\/db\/mysql\/my.cnf<br \/>\n[mysqld]<br \/>\ndatadir=\/data\/mysqlbaru<br \/>\nCreate directory tempat data baru disimpan<br \/>\n# mkdir \/data\/mysqlbaru<br \/>\nmerubah owner directory tsb menjadi milik mysql<br \/>\n#chown -R mysql:mysql \/data\/mysqlbaru<br \/>\nkemudian start mysql<br \/>\n# \/usr\/local\/etc\/rc.d\/mysql-server start<\/p>\n<p>Cara kedua adalah dengan memindah dan melakukan linking directory mysql.<br \/>\nDetailnya sbb :<\/p>\n<p>matikan server :<br \/>\n# \/usr\/local\/etc\/rc.d\/mysql-server stop<br \/>\n# cd \/var\/db<br \/>\npindahkan directory data mysql ke directory baru yang kapasitasnya lebih lega :<br \/>\n# mv mysql \/data<br \/>\nlakukan linking directory<br \/>\n# ln -s \/data\/mysql \/var\/db\/mysql<br \/>\nstart server :<\/p>\n<p># \/usr\/local\/etc\/rc.d\/mysql-server start<\/p>\n<p>Disadur dari http:\/\/www.indofreebsd.or.id\/tips-and-trick\/merubah-data-directory-pada-mysql-server-freebsd-server.html<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Secara default, jika kita install mysql server via port maka data-data dari database yang ada dalam mysql server akan tersimpan pada dir \/var\/db\/mysql Akan merepotkan kalau ternyata partisi \/var kita terlalu kecil, sehingga data nambah sedikit aja partisi \/var udah penuh. Ada 2 cara untuk mensiasati hal tsb, pertama ada merubah letak data directory pada [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-664","post","type-post","status-publish","format-standard","hentry","category-freebsd"],"_links":{"self":[{"href":"https:\/\/angga.feb.uns.ac.id\/index.php?rest_route=\/wp\/v2\/posts\/664","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/angga.feb.uns.ac.id\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/angga.feb.uns.ac.id\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/angga.feb.uns.ac.id\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/angga.feb.uns.ac.id\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=664"}],"version-history":[{"count":0,"href":"https:\/\/angga.feb.uns.ac.id\/index.php?rest_route=\/wp\/v2\/posts\/664\/revisions"}],"wp:attachment":[{"href":"https:\/\/angga.feb.uns.ac.id\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=664"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/angga.feb.uns.ac.id\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=664"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/angga.feb.uns.ac.id\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=664"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}