修改MySQL的数据目录

时间:2023-03-09 18:35:06
修改MySQL的数据目录

环境:CentOS Linux release 7.1.1503 (Core)

1. 安装MYSQL  

wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
rpm -ivh mysql-community-release-el7-.noarch.rpm
yum install mysql-community-server
serivce mysqld start

  此时查看数据目录,是/var/lib/mysql

2. 修改配置

2.1 修改安全限制

vim /etc/selinux/config

将内容修改如下:

# SELINUX=enforcing
SELINUX=permissive

2.2 修改数据库配置

首先停用MySQL。

  1. 复制数据目录

cp -R /var/lib/mysql /data/
chown -R mysql:mysql /data/mysql

  2. 修改配置

    备份/etc/my.cnf

cp /etc/my.cnf /etc/my.cnf-bk

修改/etc/my.cnf为

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid [mysqld]
log_error = /var/log/mysql-error.log
user = mysql
datadir = /data/mysql
socket = /data/mysql/mysql.sock [mysql]
socket = /data/mysql/mysql.sock
user = mysql

3. 验证

  重启mysql服务,mysql客户端登录,查看datadir

mysql>   show variables like '%dir%';
+-----------------------------------------+----------------------------+
| Variable_name | Value |
+-----------------------------------------+----------------------------+
| basedir | /usr |
| binlog_direct_non_transactional_updates | OFF |
| character_sets_dir | /usr/share/mysql/charsets/ |
| datadir | /data/mysql/ |
| ignore_db_dirs | |
| innodb_data_home_dir | |
| innodb_log_group_home_dir | ./ |
| innodb_max_dirty_pages_pct | |
| innodb_max_dirty_pages_pct_lwm | |
| innodb_undo_directory | . |
| lc_messages_dir | /usr/share/mysql/ |
| plugin_dir | /usr/lib64/mysql/plugin/ |
| slave_load_tmpdir | /tmp |
| tmpdir | /tmp |
+-----------------------------------------+----------------------------+
rows in set (0.03 sec)

配置成功!!!