迁移mysql数据目录

来自linux中国网wiki
跳到导航 跳到搜索

迁移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/

3. bak mysql data

4. start mysql 3307

mysqld_multi --tcp-ip start 2

 


测试 3307 的所有 库

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