how to change mysql data directory in ubuntu 12.04

Question

I'm trying to change the data directory of mysql. i am using 12.04 ubuntu.but i have geting error when mysql start. error is "start: Job failed to start".

I have try following things

Stop the mysql server:

stop mysql

Create the new directory:

mkdir /array2/mysql

Copy over ONLY the database folders:

cp -R /var/lib/mysql /array2/mysql
cp -R /var/lib/mysql/users /array2/mysql

Backup the my.cnf file:

cp /etc/mysql/my.cnf /root/my.cnf.backup

Edit the my.cnf file:

nano /etc/mysql/my.cnf

Change all mentions of the old datadir and socket to your new location

Mine became:

datadir=/array2/mysql

socket=/array2/mysql/mysql.sock

Update the directory permissions:

chown -R mysql:mysql /array2/mysql

Rename the old directory:

mv /var/lib/mysql /var/lib/mysql-old

Create a symlink, just in case:

ln -s /array2/mysql /var/lib/mysql

Let AppArmor know about the new datadir:

echo "alias /var/lib/mysql/ -> /your/new/datadir/," >> /etc/apparmor.d/tunables/alias

Reload the apparmor profiles

sudo /etc/init.d/apparmor reload

Then start mysql:

start mysql

Have you tried looking at mysql error log to see why is failing to start? — Esteban Garcia
– Esteban Garcia, Commented Jan 18, 2018 at 15:20

Alvaro Niño · Accepted Answer · 2018-01-18 16:31:05Z

3

I've been looking on your changes and it is not necesary to do symlinks, socket changes and/or remove old directory. Please follow this steps.

service mysql stop
cp -R /var/lib/mysql /array2/mysql
chown -R mysql.mysql /array2/mysql

Now take a backup /etc/my.cnf and then edit data dir variable

datadir                                 = /array2/mysql

Edit apparmor rules, usually in /etc/apparmor.d/usr.sbin.mysqld by adding the following lines inside /usr/sbin/mysqld group:

/array2/mysql/ r,
/array2/mysql/** rwk,

Reload app armor and start mysql service

service apparmor restart
service mysql start

Regards,

answered Jan 18, 2018 at 16:31

Alvaro Niño

5671 gold badge4 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to change mysql data directory in ubuntu 12.04

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related