ubuntu mysql 迁移_ubuntu和centos下mysql数据文件目录迁移

参考： 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