Sometimes you need change mysql data directory for the reason expand hard disk driver or rearrange your directory structure. This tutorial will show you the way to change it in Ubuntu.
For example, change mysql data directory from /var/lib/mysql to /var/data/mysql
1 |
sudo vi /etc/mysql/my.cnf |
Looking for:
1 |
datadir = /var/lib/mysql |
Change to :
1 |
datadir = /var/data/mysql |
And open file:
1 |
sudo vi /etc/apparmor.d/usr.sbin.mysqld |
Looking for:
1 2 |
/var/lib/mysql/ r, /var/lib/mysql/** rwk, |
Change to:
1 2 |
/var/data/mysql/ r, /var/data/mysql/** rwk, |
Reload AppArmor profile:
1 |
sudo /etc/init.d/apparmor reload |
Finally, restart MYSQL:
1 |
sudo /etc/init.d/mysql restart |
It’s done.