
MySQL database storage path change
Mysql data storage path modification /
Find the Mysql configuration file
find / -name 'my.cnf'
Edit the following code
datadir = /data/mysql
/data/mysql is the new path directory for mysql data storage.
Copy the original data to the new directory
cp -R /var/data/mysql/* /data/mysql
tips:you should be stop mysql service first
💘 相关文章
- mysql database connection failed | SQLSTATE[HY000] [2002] Connection refused solution
- Personal blog database selection, mysql vs sqlite?
- Implementation method of regular backup of MySQL database
- 'ldconfig' not found in PATH or not executable解决方法
- mysql数据存储路径修改
- Mac PHP mysql 一键工具包
- mysql批量替換數據庫字符的方法
- MySQL在Mac系統通過brew安裝以及重啟的方法
- mysql数据库链接失败| SQLSTATE[HY000] [2002] Connection refused 解決方法
- MySQL remote connection configuration method under docker container