查看“迁移mysql数据目录”的源代码


迁移mysql数据目录

== pre ==

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

&nbsp;


== 1.stop mysql 3307 ==

 mysqld_multi --tcp-ip stop 2

&nbsp;

  ##here stop mysql 后   

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

 chown -R mysql:root /data1/mysql2/

&nbsp;

== 2. change config file ==
<pre>[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/
</pre>

== 3. bak mysql data ==

== 4. start mysql 3307 ==

 mysqld_multi --tcp-ip start 2

&nbsp;



== 测试 3307 的所有 库 ==
<pre>mysql(root (none))>show databases;
+--------------------+
| Database           |
+--------------------+
| m_c             |
</pre>

  create database evantest;

[[Category:Mysql]]