迁移mysql数据目录

迁移mysql数据目录

pre

rsync -avz /data/mysql2/data/ /data1/mysql2/data/

 

1.stop mysql 3307

mysqld_multi --tcp-ip stop 2

 

 ##here stop mysql 后   

rsync -avz /data/mysql2/data/ /data1/mysql2/data/

chown -R mysql:root /data1/mysql2/

 

2. change config file

[mysqld2] pid-file = /data/mysql2/data/mysql2.pid datadir = /data/mysql2/data tmpdir = /data/mysql2/data port = 3307 socket = /tmp/mysql2.sock

改为 pid-file = /data1/mysql2/data/mysql2.pid datadir = /data1/mysql2/data tmpdir = /data1/mysql2/data

cd /data1/mysql2/data/ mv mysql2.pid mysql2.pidbak

diff /data/mysql2/data/ /data1/mysql2/data/

4. start mysql 3307

mysqld_multi --tcp-ip start 2

 

测试 3307 的所有 库

mysql(root (none))>show databases;
+--------------------+
| Database           |
+--------------------+
| m_c             |

 create database evantest;