Home > Database > Mysql Tutorial > body text

MySQL data的存储目录变更

WBOY
Release: 2016-06-07 17:59:03
Original
1251 people have browsed it

1: MySQL对于基于 rpm 安装的系统 ,修改其数据源的目录,采用修改 etc/init.d 下的mysql 文件 修改里面的 datadir=/data/mysql/data 即可 2: 对于采用源码编译的系统。直接修改my.cnf文件,修改添加datadir=/data/mysql/data 即可 - 目前不清楚为什么采用 .

1: MySQL对于基于 rpm 安装的系统 ,修改其数据源的目录,采用修改

etc/init.d 下的mysql 文件

修改里面的

datadir=/data/mysql/data

即可

2: 对于采用源码编译的系统。直接修改my.cnf文件,修改添加datadir=/data/mysql/data 即可

-

目前不清楚为什么采用

./scripts/mysql_install_db  --user=mysql --basedir=/usr/local/mysql/ --datadir=/home/li/data/ 的方式不起作用
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!