参考: http://www.dbaxiaoyu.com/archives/1494
http://database.51cto.com/art/200905/125833.htm
[root@localhost ~]# mkdir /data
[root@localhost ~]# chown -R mysql:mysql /data
[root@localhost ~]# mv /var/lib/mysql/
/data/ #或者 cp -arp /var/lib/mysql/ /data/ [root@localhost ~]# ls -l /data/mysql/
修改/etc/my.cnf文件
[client]
#password = your_password
port = 3306
socket = /data/mysql/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
port = 3306
socket = /data/mysql/mysql.sock
datadir=/data/mysql
这里主要修改了:
client的socket变量/data/mysql/mysql.sock
mysqld的变量socket = /data/mysql/mysql.sock
datadir=/data/mysql
[root@localhost ~]# vim
/etc/apparmor.d/usr.sbin.mysqld
添加:
/data/mysql/ r,
/data/mysql/** rwk,
然后重新启动apparmor 和 mysql
[root@localhost ~]# /etc/init.d/apparmor
reload
[root@localhost ~]# service mysql restart
Shutting down MySQL.[ OK ]
Starting MySQL..[ OK ]
mysql> show variables like 'datadir';
+---------------+--------------+
| Variable_name | Value |
+---------------+--------------+
| datadir | /data/mysql/ |
+---------------+--------------+
1 row in set (0.00 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
4 rows in set (0.03 sec)
此时mysql的数据文件目录已经迁移完成。
centos下迁移 参照:
http://wenku.baidu.com/link?url=QK0mePZUy6lNmWFH-p35MhLnmDus94qqV7QNTRQVz98wrvaiiOxDdbn-RHoY9NH47i54-MS-_CEUFBx80k9Ir6_i1fK2bKBLoVt4UFHSiOW
http://jishu.zol.com.cn/11699.html