Modify the MySQL Data directory

Environment: CentOS Linux release 7.1.1503 (Core)

1. Install MySQL

wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpmRPM-IVH mysql-community-release-el7-5yuminstall mysql-community-Serverserivce Mysqld Start

Now look at the data directory, which is/var/lib/mysql

2. Modify the configuration

2.1 Modifying security restrictions

Vim/etc/selinux/config

Modify the content as follows:

# selinux=enforcingselinux=permissive

2.2 Modifying the database configuration

start by disabling MySQL.

1. Copying Data Catalog

CP -r/var/lib/mysql/data/chown -R mysql:mysql/data/mysql

2. Modify the configuration

Backup/etc/my.cnf

CP /ETC/MY.CNF/ETC/MY.CNF-BK

Modify/ETC/MY.CNF to

[Mysqld_safe]log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/=/var/ log/mysql-==/data/=/data/mysql/=/data/mysql/= MySQL

3. Verification

Restart MySQL service, MySQL client login, view 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 | the|| INNODB_MAX_DIRTY_PAGES_PCT_LWM |0||                          Innodb_undo_directory |. || Lc_messages_dir | /usr/share/mysql/| | Plugin_dir | /usr/lib64/mysql/plugin/| | Slave_load_tmpdir | /tmp | | Tmpdir | /tmp |+-----------------------------------------+----------------------------+ -RowsinchSet (0.03Sec

Configuration success!!!

Modify the MySQL Data directory