
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
- 轻量级的Php mysql web 管理客户端程序Adminer
- mysql严格模式引起1364 错误提示的處理過程的一些坑
- mysql定時去重的方法
- Hetzner 備份服務器STORAGE BOXES掛載為目錄的方法
- 收藏:MySQL 數值型函數大全
- 抛弃phpmyadmin吧,一款非常强大的MySQL GUI客户端-HeidiSQL
- Starting MySQL... ERROR! ……quit without updating PID file (/opt/mysql/data/mysql.pid)解決方法