{"id":671,"date":"2008-06-05T09:09:48","date_gmt":"2008-06-05T02:09:48","guid":{"rendered":"http:\/\/adhi.widjajanto.net\/weblog\/index.php\/2008\/06\/05\/cara_memindahka\/"},"modified":"2015-06-05T14:26:13","modified_gmt":"2015-06-05T07:26:13","slug":"cara_memindahka","status":"publish","type":"post","link":"https:\/\/adhi.widjajanto.net\/blog\/2008\/06\/05\/cara_memindahka\/","title":{"rendered":"Cara memindahkan mysql datadir di Ubuntu 8.04"},"content":{"rendered":"<p>Memindahkan datadir mysql di Ubuntu 8.04 tidak segampang di Windows atau di *Nix lainnya yang sering saya lakukan. Ada satu file &#038; daemon yang harus disentuh juga. Ini lengkapnya:<\/p>\n<ul>\n<li>matikan mysql dengan <strong>\/etc\/init.d\/mysql stop<\/strong><\/li>\n<li>pindahkan datadir dengan <strong>mv \/var\/lib\/mysql \/warehouse\/mysql -p -r<\/strong><\/li>\n<li><strong>vi \/etc\/mysql\/my.cnf<\/strong>, ganti parameter <strong>datadir = \/usr\/lib\/mysql<\/strong> menjadi <strong>datadir = \/warehouse\/mysql<\/strong><\/li>\n<li><strong>vi \/etc\/apparmor.d\/usr.sbin.mysqld<\/strong>, ganti baris yang ada <strong>\/usr\/lib\/mysql<\/strong> dengan <strong>\/warehouse\/mysql<\/strong> (ada dua baris)<\/li>\n<li>restart apparmor dengan <strong>\/etc\/init.d\/apparmor restart<\/strong><\/li>\n<li>start mysql dengan <strong>\/etc\/init.d\/mysql start<\/strong><\/li>\n<\/ul>\n<p>Langkah ke-5 &#038; 6 itu yang tak ada di OS lain.<br \/>\nSekarang sudah beres. MySQL saya jalan di harddisk baru, 250GB<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Memindahkan datadir mysql di Ubuntu 8.04 tidak segampang di Windows atau di *Nix lainnya yang sering saya lakukan. Ada satu file &#038; daemon yang harus disentuh juga. Ini lengkapnya: matikan mysql dengan \/etc\/init.d\/mysql stop pindahkan datadir dengan mv \/var\/lib\/mysql \/warehouse\/mysql -p -r vi \/etc\/mysql\/my.cnf, ganti parameter datadir = \/usr\/lib\/mysql menjadi&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"footnotes":""},"categories":[8],"tags":[],"class_list":["post-671","post","type-post","status-publish","format-standard","hentry","category-it-freaks"],"_links":{"self":[{"href":"https:\/\/adhi.widjajanto.net\/blog\/wp-json\/wp\/v2\/posts\/671","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/adhi.widjajanto.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/adhi.widjajanto.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/adhi.widjajanto.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/adhi.widjajanto.net\/blog\/wp-json\/wp\/v2\/comments?post=671"}],"version-history":[{"count":1,"href":"https:\/\/adhi.widjajanto.net\/blog\/wp-json\/wp\/v2\/posts\/671\/revisions"}],"predecessor-version":[{"id":1675,"href":"https:\/\/adhi.widjajanto.net\/blog\/wp-json\/wp\/v2\/posts\/671\/revisions\/1675"}],"wp:attachment":[{"href":"https:\/\/adhi.widjajanto.net\/blog\/wp-json\/wp\/v2\/media?parent=671"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/adhi.widjajanto.net\/blog\/wp-json\/wp\/v2\/categories?post=671"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/adhi.widjajanto.net\/blog\/wp-json\/wp\/v2\/tags?post=671"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}