一、查看当前存储目录
mysql -uroot -p
输入密码后根据语句查询
mysql> select @@datadir;
+------------------+
| @@datadir |
+------------------+
| /data/mysql/var/ |
+------------------+
1 row in set (0.00 sec)二、停止mysql
/etc/init.d/mysql stop三、数据迁移
rsync -av /usr/local/mysql/var/ /data/mysql/var/三、修改配置
vi /etc/my.cnf 修改my.cnf文件下的datadir 到你要存储的位置
[mysqld]
port = 3306
socket = /tmp/mysql.sock
datadir = /data/mysql/var例如：
datadir = /data/mysql/var