MySQL change data directory 2019-01-03 02:03
The default data directory of MySQL is /var/lib/mysql. If there is no disk space for this directory we need to move data to another directory(another fileSystem). In my environment I install MySQL by yum command. The /var/lib/mysql directory is mounted on / and there is no more space for data. I change data directory by using these following commands.
[root@virtual ~]# service mysqld stop
Stopping mysqld: [ OK ]
[root@virtual ~]# mkdir mysql_data
[root@virtual ~]# mv /var/lib/mysql/ ~/mysql_data/
[root@virtual ~]# chown -R mysql:mysql mysql_data
[root@virtual ~]# ln -s ~/mysql_data/mysql /var/lib/
[root@virtual ~]# service mysqld start
Starting mysqld: [ OK ]
EOF