Linux MySQL 更改数据存储目录
MySQL Linux CentOS 大约 367 字查看当前数据存储目录
select @@datadir;
停止MySQL服务
service mysqld stop
备份datadir
cp /var/lib/mysql /var/lib/mysql.bak
修改存储目录
配置文件中指定存储目录
[client]
socket=/home/mysql/data/mysql.sock
[mysqld]
datadir =/home/mysql/data
socket=/home/mysql/data/mysql.sock
拷贝先前数据
cp -r /var/lib/mysql /home/mysql/data
修改存储目录归属用户
chown -R mysql:mysql /home/mysql/data
重启MySQL服务即可
service mysqld start
阅读 2199 · 发布于 2019-09-30
————        END        ————
Give me a Star, Thanks:)
https://github.com/fendoudebb扫描下方二维码关注公众号和小程序↓↓↓
昵称:
随便看看
换一批
-
MySQL 查询冗余索引阅读 2664
-
skaffold init 提示 one or more valid Kubernetes manifests are required to run skaffold阅读 1166
-
Docker WARNING IPv4 forwarding is disabled. Networking will not work阅读 1191
-
JavaScript 页面切换后更改标题阅读 1551
-
走进 Spring Boot 之第三步 SpringApplication run 方法阅读 3202
-
Arthas 使用 watch 命令观察返回值、抛出异常、入参阅读 7323
-
Java WebSocket The remote endpoint was in state [TEXT_FULL_WRITING] which is an invalid state for called method阅读 5464
-
Spring Boot OpenFeign 打印完整请求日志阅读 2006
-
Kubernetes ConfigMap 创建失败 cannot unmarshal number into Go struct field ConfigMap.data of type string阅读 3457
-
软考-系统架构设计师:OSI/RM 七层模型阅读 2680