Ubuntu MySQL 二进制版修改data目录

系统Ubuntu 16.04 x64MySQL 5.5.16安装MySQL请参考https://my.oschina.net/zhanlzy/blog/1036384示例原目录：/usr/local/

系统

• Ubuntu 16.04 x64
• MySQL 5.5.16

安装MySQL请参考https://my.oschina.net/zhanlzy/blog/1036384

示例原目录：/usr/local/mysql/data/

示例新目录：/mythware/mysql/data/

1.停止mysqld服务

service mysql stop

2.复制数据库到新目录

cp -R /usr/local/mysql/data/* /mythware/mysql/data/

3.赋于mysql目录权限

chown -R mysql:mysql /mythware/mysql/data/

4.修改mysql配置文件

vim /etc/mysql/my.cnf#datadir = /usr/local/mysql/data/datadir = /mythware/mysql/data/

5.启动mysql服务

service mysql start

参考：

1. http://blog.csdn.net/jom_ch/article/details/4059393
2. http://blog.csdn.net/lyhvoyage/article/details/50521440