1.修改配置文件 vim /etc/mysql/my.cnf 修改成你想要更改的路径 datadir =/var/lib/mysql 改为 datadir =/home/mysqldata/mysql 2新建目录 mkdir /home/mysqldata mkdir /home/mysqldata/mysql 3配置权限 chown root:root /home/m
vim /etc/mysql/my.cnf
修改成你想要更改的路径
datadir =/var/lib/mysql
改为
datadir =/home/mysqldata/mysql
2新建目录
mkdir /home/mysqldata
mkdir /home/mysqldata/mysql
3配置权限
chown root:root /home/mysqldata
chown mysql:mysql /home/mysqldata/mysql
4.移动现有数据库
mv /var/lib/mysql /home/mysqldata/
5.重启数据库
/et/init.d/mysql restart
重启后在终端会提示
Checking for corrupt, not cleanly closed and upgrade needing tables..
这个错误可以忽略,当然也可以在mysql下执行 upgrade
阅读()
评论 0