{"id":2276,"date":"2018-05-05T13:42:23","date_gmt":"2018-05-05T08:12:23","guid":{"rendered":"https:\/\/blog.pheonixsolutions.com\/?p=2276"},"modified":"2018-05-05T13:42:23","modified_gmt":"2018-05-05T08:12:23","slug":"change-mysql-data-directory-on-cpanel-safely-move-mysql-data-directory-centos","status":"publish","type":"post","link":"https:\/\/pheonixsolutions.com\/blog\/change-mysql-data-directory-on-cpanel-safely-move-mysql-data-directory-centos\/","title":{"rendered":"Change mysql data directory on cPanel| Safely move mysql data directory – Centos"},"content":{"rendered":"

Change mysql data directory on cPanel| Safely move mysql data directory – Centos<\/h3>\n

Date Posted: 05-05-2018<\/strong><\/p>\n

This post explains on how to move or setup different data directory for mysql application. If there is no database exists, skip the first step. This post deals with moving data directory to \/home\/mysql<\/p>\n

Create an existing data directory in a tar file. The default data directory for mysql is\u00a0\/var\/lib\/mysql<\/em><\/p>\n

tar -cvf mysql.tar \/var\/lib\/mysql<\/code><\/p>\n

Create the directory \/home\/mysql<\/p>\n

mkdir -p \/home\/mysql<\/code><\/p>\n

Now, rsync the data directory from \/var\/lib\/mysql to \/home\/mysql. If the data directory is huge then we recommend to run rsync process in screen<\/p>\n

screen -S rsync<\/code><\/p>\n

rsync -avp \/var\/lib\/mysql\/ \/home\/mysql<\/code><\/p>\n

Press\u00a0Ctrl + A +\u00a0 D\u00a0<\/strong>to come out of screen<\/p>\n

Depends on the size of the directory , it may take little while.\u00a0 Now, open the screen and view the progress state.<\/p>\n

screen -ls<\/code><\/p>\n

screen -x screenID<\/code><\/p>\n

Now, stop the mysql service.<\/p>\n

\/etc\/init.d\/mysql stop<\/code><\/p>\n

Initiate the rsync process again to copy the data directory.<\/p>\n

rsync -avp --delete \/var\/lib\/mysql\/ \/home\/mysql\/<\/code><\/p>\n

Change the permission of new data directory with mysql<\/p>\n

chown -R mysql.mysql \/home\/mysql<\/code><\/p>\n

Edit the mysql configuration with new data directory(\/etc\/my.cnf)<\/p>\n

vi \/etc\/my.cnf<\/code><\/p>\n

datadirectory=\/home\/mysql<\/p><\/blockquote>\n

Now, start the mysql service.<\/p>\n

\/etc\/init.d\/mysql start<\/code><\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Change mysql data directory on cPanel| Safely move mysql data directory – Centos Date Posted: 05-05-2018 This post explains on how to move or setup different data directory for mysql application. If there is no database exists, skip the first step. This post deals with moving data directory to \/home\/mysql… Continue Reading Change mysql data directory on cPanel| Safely move mysql data directory – Centos<\/span><\/i><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[369,225],"tags":[263,261,179],"class_list":{"0":"post-2276","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"hentry","6":"category-cpanel-controlpanel","7":"category-linux","8":"tag-cpanel","9":"tag-linux","10":"tag-mysql-2","11":"h-entry","13":"h-as-article"},"yoast_head":"\nPheonix Solutions - We Empower Your Business Growth<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/pheonixsolutions.com\/blog\/change-mysql-data-directory-on-cpanel-safely-move-mysql-data-directory-centos\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pheonix Solutions - We Empower Your Business Growth\" \/>\n<meta property=\"og:description\" content=\"Change mysql data directory on cPanel| Safely move mysql data directory – Centos Date Posted: 05-05-2018 This post explains on how to move or setup different data directory for mysql application. If there is no database exists, skip the first step. This post deals with moving data directory to \/home\/mysql… Continue Reading Change mysql data directory on cPanel| Safely move mysql data directory – Centos\" \/>\n<meta property=\"og:url\" content=\"https:\/\/pheonixsolutions.com\/blog\/change-mysql-data-directory-on-cpanel-safely-move-mysql-data-directory-centos\/\" \/>\n<meta property=\"og:site_name\" content=\"PHEONIXSOLUTIONS\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/PheonixSolutions-209942982759387\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-05-05T08:12:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2016\/09\/PX2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"3837\" \/>\n\t<meta property=\"og:image:height\" content=\"2540\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@pheonixsolution\" \/>\n<meta name=\"twitter:site\" content=\"@pheonixsolution\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/change-mysql-data-directory-on-cpanel-safely-move-mysql-data-directory-centos\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/change-mysql-data-directory-on-cpanel-safely-move-mysql-data-directory-centos\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#\\\/schema\\\/person\\\/0ffa33d73c869faec2d50e79c24e3503\"},\"headline\":\"Change mysql data directory on cPanel| Safely move mysql data directory – Centos\",\"datePublished\":\"2018-05-05T08:12:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/change-mysql-data-directory-on-cpanel-safely-move-mysql-data-directory-centos\\\/\"},\"wordCount\":190,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#organization\"},\"keywords\":[\"cPanel\",\"Linux\",\"mysql\"],\"articleSection\":[\"cPanel\",\"Linux\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/change-mysql-data-directory-on-cpanel-safely-move-mysql-data-directory-centos\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/change-mysql-data-directory-on-cpanel-safely-move-mysql-data-directory-centos\\\/\",\"url\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/change-mysql-data-directory-on-cpanel-safely-move-mysql-data-directory-centos\\\/\",\"name\":\"Pheonix Solutions - We Empower Your Business Growth\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#website\"},\"datePublished\":\"2018-05-05T08:12:23+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/change-mysql-data-directory-on-cpanel-safely-move-mysql-data-directory-centos\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/change-mysql-data-directory-on-cpanel-safely-move-mysql-data-directory-centos\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/change-mysql-data-directory-on-cpanel-safely-move-mysql-data-directory-centos\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Change mysql data directory on cPanel| Safely move mysql data directory – Centos\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/\",\"name\":\"Pheonix Solutions\",\"description\":\"We Empower Your Business Growth\",\"publisher\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#organization\",\"name\":\"PheonixSolutions\",\"url\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/12\\\/logo.png\",\"contentUrl\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/12\\\/logo.png\",\"width\":454,\"height\":300,\"caption\":\"PheonixSolutions\"},\"image\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/PheonixSolutions-209942982759387\\\/\",\"https:\\\/\\\/x.com\\\/pheonixsolution\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#\\\/schema\\\/person\\\/0ffa33d73c869faec2d50e79c24e3503\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/09bacc0294abee1322a23ab4bc6a0330dd4cb4df707dc9d0b0efeba6c109608b?s=96&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/09bacc0294abee1322a23ab4bc6a0330dd4cb4df707dc9d0b0efeba6c109608b?s=96&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/09bacc0294abee1322a23ab4bc6a0330dd4cb4df707dc9d0b0efeba6c109608b?s=96&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"http:\\\/\\\/blog.pheonixsolutions.com\"],\"url\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Pheonix Solutions - We Empower Your Business Growth","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/pheonixsolutions.com\/blog\/change-mysql-data-directory-on-cpanel-safely-move-mysql-data-directory-centos\/","og_locale":"en_US","og_type":"article","og_title":"Pheonix Solutions - We Empower Your Business Growth","og_description":"Change mysql data directory on cPanel| Safely move mysql data directory – Centos Date Posted: 05-05-2018 This post explains on how to move or setup different data directory for mysql application. If there is no database exists, skip the first step. This post deals with moving data directory to \/home\/mysql… Continue Reading Change mysql data directory on cPanel| Safely move mysql data directory – Centos","og_url":"https:\/\/pheonixsolutions.com\/blog\/change-mysql-data-directory-on-cpanel-safely-move-mysql-data-directory-centos\/","og_site_name":"PHEONIXSOLUTIONS","article_publisher":"https:\/\/www.facebook.com\/PheonixSolutions-209942982759387\/","article_published_time":"2018-05-05T08:12:23+00:00","og_image":[{"width":3837,"height":2540,"url":"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2016\/09\/PX2.png","type":"image\/png"}],"author":"admin","twitter_card":"summary_large_image","twitter_creator":"@pheonixsolution","twitter_site":"@pheonixsolution","twitter_misc":{"Written by":"admin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/pheonixsolutions.com\/blog\/change-mysql-data-directory-on-cpanel-safely-move-mysql-data-directory-centos\/#article","isPartOf":{"@id":"https:\/\/pheonixsolutions.com\/blog\/change-mysql-data-directory-on-cpanel-safely-move-mysql-data-directory-centos\/"},"author":{"name":"admin","@id":"https:\/\/pheonixsolutions.com\/blog\/#\/schema\/person\/0ffa33d73c869faec2d50e79c24e3503"},"headline":"Change mysql data directory on cPanel| Safely move mysql data directory – Centos","datePublished":"2018-05-05T08:12:23+00:00","mainEntityOfPage":{"@id":"https:\/\/pheonixsolutions.com\/blog\/change-mysql-data-directory-on-cpanel-safely-move-mysql-data-directory-centos\/"},"wordCount":190,"commentCount":0,"publisher":{"@id":"https:\/\/pheonixsolutions.com\/blog\/#organization"},"keywords":["cPanel","Linux","mysql"],"articleSection":["cPanel","Linux"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/pheonixsolutions.com\/blog\/change-mysql-data-directory-on-cpanel-safely-move-mysql-data-directory-centos\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/pheonixsolutions.com\/blog\/change-mysql-data-directory-on-cpanel-safely-move-mysql-data-directory-centos\/","url":"https:\/\/pheonixsolutions.com\/blog\/change-mysql-data-directory-on-cpanel-safely-move-mysql-data-directory-centos\/","name":"Pheonix Solutions - We Empower Your Business Growth","isPartOf":{"@id":"https:\/\/pheonixsolutions.com\/blog\/#website"},"datePublished":"2018-05-05T08:12:23+00:00","breadcrumb":{"@id":"https:\/\/pheonixsolutions.com\/blog\/change-mysql-data-directory-on-cpanel-safely-move-mysql-data-directory-centos\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/pheonixsolutions.com\/blog\/change-mysql-data-directory-on-cpanel-safely-move-mysql-data-directory-centos\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/pheonixsolutions.com\/blog\/change-mysql-data-directory-on-cpanel-safely-move-mysql-data-directory-centos\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/pheonixsolutions.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Change mysql data directory on cPanel| Safely move mysql data directory – Centos"}]},{"@type":"WebSite","@id":"https:\/\/pheonixsolutions.com\/blog\/#website","url":"https:\/\/pheonixsolutions.com\/blog\/","name":"Pheonix Solutions","description":"We Empower Your Business Growth","publisher":{"@id":"https:\/\/pheonixsolutions.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/pheonixsolutions.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/pheonixsolutions.com\/blog\/#organization","name":"PheonixSolutions","url":"https:\/\/pheonixsolutions.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pheonixsolutions.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2016\/12\/logo.png","contentUrl":"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2016\/12\/logo.png","width":454,"height":300,"caption":"PheonixSolutions"},"image":{"@id":"https:\/\/pheonixsolutions.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/PheonixSolutions-209942982759387\/","https:\/\/x.com\/pheonixsolution"]},{"@type":"Person","@id":"https:\/\/pheonixsolutions.com\/blog\/#\/schema\/person\/0ffa33d73c869faec2d50e79c24e3503","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/09bacc0294abee1322a23ab4bc6a0330dd4cb4df707dc9d0b0efeba6c109608b?s=96&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/09bacc0294abee1322a23ab4bc6a0330dd4cb4df707dc9d0b0efeba6c109608b?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/09bacc0294abee1322a23ab4bc6a0330dd4cb4df707dc9d0b0efeba6c109608b?s=96&r=g","caption":"admin"},"sameAs":["http:\/\/blog.pheonixsolutions.com"],"url":"https:\/\/pheonixsolutions.com\/blog\/author\/admin\/"}]}},"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p7F4uM-AI","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/2276","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=2276"}],"version-history":[{"count":0,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/2276\/revisions"}],"wp:attachment":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=2276"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=2276"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=2276"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}