假设数据库原来的存放目录为/usr/local/mysql/var
新的目录为/var/mysql
1./usr/local/mysql/share/mysql/mysql.server stop
2.mkdir /var/mysql
chown -R mysql /var/mysql
chgrp -R mysql /var/mysql
3.vi /etc/my.cnf
add: datadir=/var/mysql
log-bin=/var/mysql/mysql-bin
4./usr/local/mysql/share/mysql/mysql.server start
阅读(1218) | 评论(0) | 转发(0) |
