mysql修改datadir目录

 

 

mysql> show variables like "%datadir%";
+---------------+-----------------+
| Variable_name | Value           |
+---------------+-----------------+
| datadir       | /var/lib/mysql/ |
+---------------+-----------------+
1 row in set (0.01 sec)

 

mysql> shutdown;
Query OK, 0 rows affected (0.00 sec)

 

cp -r /var/lib/mysql ./db1

chown -R mysql.mysql db1

 

vim /etc/mysql/my.cnf

datadir=/source/data/mysql/db1

 

/etc/init.d/mysql start