{"id":55,"date":"2010-09-20T20:53:01","date_gmt":"2010-09-20T17:53:01","guid":{"rendered":"http:\/\/meekconsulting.com\/?p=55"},"modified":"2010-09-20T20:53:01","modified_gmt":"2010-09-20T17:53:01","slug":"moving-mysql-database-data-directories-to-new-partition","status":"publish","type":"post","link":"https:\/\/meekconsulting.com\/?p=55","title":{"rendered":"Moving Mysql database data directories to new partition"},"content":{"rendered":"<p>If you need to move a mysql database\u2019s data files to another partition because space on \/var\/lib\/mysql is getting low you can do this:<\/p>\n<p>1) Shut down the database <\/p>\n<blockquote><p>\nservice mysqld stop\n<\/p><\/blockquote>\n<p>2) move the database files using cpdir<\/p>\n<blockquote><p>\ncd \/var\/lib\/mysql\/databasename<br \/>\nfind . -depth  -mount -print | cpio -pdmv \/NEWPARTITION\/mysql\/databasename\n<\/p><\/blockquote>\n<p>3) Rename the old directory<br \/>\n4) Create a symbolic link between old and new directory<\/p>\n<p>5) Fix context (SE linux Permissions) on the new directory has good SELINUX permissions.<\/p>\n<blockquote><p>\nchcon -R -u system_u -r object_r -t mysqld_db_t \/NEWPART\/mysql\n<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>If you need to move a mysql database\u2019s data files to another partition because space on \/var\/lib\/mysql is getting low you can do this: 1) Shut down the database service mysqld stop 2) move the database files using cpdir cd &hellip; <a href=\"https:\/\/meekconsulting.com\/?p=55\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/meekconsulting.com\/index.php?rest_route=\/wp\/v2\/posts\/55"}],"collection":[{"href":"https:\/\/meekconsulting.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/meekconsulting.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/meekconsulting.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/meekconsulting.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=55"}],"version-history":[{"count":1,"href":"https:\/\/meekconsulting.com\/index.php?rest_route=\/wp\/v2\/posts\/55\/revisions"}],"predecessor-version":[{"id":56,"href":"https:\/\/meekconsulting.com\/index.php?rest_route=\/wp\/v2\/posts\/55\/revisions\/56"}],"wp:attachment":[{"href":"https:\/\/meekconsulting.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=55"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/meekconsulting.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=55"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/meekconsulting.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=55"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}