MySQL修改datadir目录

最新推荐文章于 2024-06-14 14:05:19 发布

哈维敖尔

最新推荐文章于 2024-06-14 14:05:19 发布

阅读量2.5k

点赞数 2

文章标签： mysql 数据库 linux

本文链接：https://blog.csdn.net/weixin_41851830/article/details/125060872

版权

MySQL修改datadir目录

更改MySQL的数据目录由/var/lib/mysql/更换至/data/mysql/

1）关闭MySQL

[root@test2 ~]# systemctl stop mysqld
Shutting down MySQL..................                      [  OK  ]

2）datadir和socket的目录

datadir=/data/mysql  
socket=/data/mysql/mysql.sock

3）拷贝数据文件

mkdir -p /data/mysql  
chown -R mysql:mysql /data/mysql
cp -a var/lib/mysql/* /data/mysql/

4）启动MySQL

[root@test2 ~]# systemctl start mysql
Starting MySQL.........                                    [  OK  ]

5）问题解决

更改了mysql的配置文件，重新启动的时候发现：启动失败：

Job for mysqld.service failed because the control process exited with error code. See “systemctl status mysqld.service” and “journalctl -xe” for details.

查看日志：

Loaded: loaded (/etc/rc.d/init.d/mysqld; bad; vendor preset: disabled)

Can’t create test file /home/mysql/data/d064lh.lower-test

原因就是

SELinux惹的祸

通俗的讲就是linux服务器的安全策略

这个文章可以看看：https://linux.cn/article-7317-1.html

https://www.iteye.com/blog/jejoker-1882028

解决：

临时关闭：setenforce 0

永久关闭需要修改配置文件，重启机器：

修改/etc/selinux/config 文件

将SELINUX=enforcing改为SELINUX=disabled

也有可能是apparmor问题

https://www.cnblogs.com/Amaranthus/p/5738332.html

6）不修改/etc/my.cnf利用软连接的方法

rm -rf /var/lib/mysql
ln -s /var/lib/mysql /data/mysql
chown -R mysql:mysql /data/mysql
systemctl start mysql

7)测试

mysql> show variables like '%datadir%';
+---------------+--------------+
| Variable_name | Value        |
+---------------+--------------+
| datadir       | /data/mysql/ |
+---------------+--------------+
1 row in set (0.01 sec)

mysql> create database hch;
Query OK, 1 row affected (0.10 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| OMServer           |
| ceshi              |
| hch                |
| hchtest            |
| hchtest1           |
| mysql              |
| percona            |
| performance_schema |
| rep_test           |
| repldb             |
| repldb1            |
| test               |
| wna                |
+--------------------+
14 rows in set (0.00 sec)

mysql> use hch;
Database changed

mysql> create table t1(id int);
Query OK, 0 rows affected (0.15 sec)

mysql> insert into t1 values(1);
Query OK, 1 row affected (0.08 sec)

mysql> insert into t1 values(2);
Query OK, 1 row affected (0.00 sec)

mysql> select * from t1;
+------+
| id   |
+------+
|    1 |
|    2 |
+------+
2 rows in set (0.00 sec)