{"id":1281,"date":"2015-02-12T07:24:16","date_gmt":"2015-02-12T06:24:16","guid":{"rendered":"http:\/\/oprsteny.cz\/?p=1281"},"modified":"2015-02-13T14:21:58","modified_gmt":"2015-02-13T13:21:58","slug":"linux-move-mysql-data-directory","status":"publish","type":"post","link":"https:\/\/oprsteny.cz\/?p=1281","title":{"rendered":"LINUX – Move MySQL data directory"},"content":{"rendered":"

\"Linux\"In newer versions of Linux it’s not easily possible to just move the MySQL data directory to another location and modify my.cnf or create a symbolic link. There is a secutity\/protection “daemon” running in background checking which locations is some process trying to access. If it’s allowed, then access is granted, otherwise the process is unable to read\/write the required data. This guardian is called “APPARMOR”<\/p>\n

I wanted to move the MySQL<\/em> data directory (among others, like \/var\/www<\/em>, git<\/em> projects repositories, owncloud<\/em> data directory, media like photos<\/em>, videos<\/em>, music<\/em>, …) to another location on my file system due to separation of data from the rest of the running system – in case of failure I’d just re-install the system, but data stored on separated partition will remain untouched and can just be binded\/mounted to the fresh installed system.<\/p>\n

Let’s assume I’ve my data partition mounted as \/mnt\/data. <\/em>So I moved the MySQL data directory there using:<\/p>\n

sudo mv \/var\/lib\/mysql \/mnt\/data<\/pre>\n
And created a symbolic link on original location<\/p>\n
cd \/var\/lib\r\nsudo ln -s \/mnt\/data\/mysql<\/pre>\n
When I tried to start MySQL server daemon I got the following error message:<\/p>\n
start: Job failed to start<\/pre>\n
So I edited the Apparmor configuration alias file for MySQL:<\/p>\n
sudo nano \/etc\/apparmor.d\/tunables\/alias<\/pre>\n
with the following content:<\/p>\n
...\r\nalias \/var\/lib\/mysql\/ -> \/backup\/mysql\/,\r\n...<\/pre>\n
and reloaded the configuration using command<\/p>\n
sudo \/etc\/init.d\/apparmor reload<\/pre>\n
Now the MySQL server should be started correctly<\/p>\n
mysql start\/running, process 27288<\/pre>\n","protected":false},"excerpt":{"rendered":"
In newer versions of Linux it’s not easily possible to just move the MySQL data directory to another location and modify my.cnf or create a symbolic link. There is a secutity\/protection “daemon” running in background checking which locations is some … Continue reading →<\/span><\/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":"","jetpack_publicize_message":"LINUX - Move MySQL data directory","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[39,45,38,5],"tags":[387,66],"class_list":["post-1281","post","type-post","status-publish","format-standard","hentry","category-infrastructure","category-linux","category-software","category-tools","tag-apparmor","tag-mysql"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p3nYbe-kF","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/oprsteny.cz\/index.php?rest_route=\/wp\/v2\/posts\/1281","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oprsteny.cz\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oprsteny.cz\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oprsteny.cz\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oprsteny.cz\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1281"}],"version-history":[{"count":4,"href":"https:\/\/oprsteny.cz\/index.php?rest_route=\/wp\/v2\/posts\/1281\/revisions"}],"predecessor-version":[{"id":1287,"href":"https:\/\/oprsteny.cz\/index.php?rest_route=\/wp\/v2\/posts\/1281\/revisions\/1287"}],"wp:attachment":[{"href":"https:\/\/oprsteny.cz\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1281"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oprsteny.cz\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1281"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oprsteny.cz\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1281"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}