mysqldump 를 이용한 백업 및 복구 방법

1. full dump 백업 [master]

<session 1>
mysql> flush tables with read lock;
mysql> show master status\G

*************************** 1. row ***************************
File: mysql-bin.000001
Position: 453
Binlog_Do_DB:
Binlog_Ignore_DB:
1 row in set (0.00 sec)

<session 2>
shell> mysqldump -uroot -p --all-databases > all_db_master.sql

<session 1>
mysql> unlock tables;

2. file 전송 [master]
scp -P all_db_master.sql 30.34.34.6:/DB/DATA/

3. dump 파일을 이용한 복구 [standby]
mysql> stop slave;
mysql> reset slave;
shell> mysql -uroot -p < all_db_master.sql

4. replication 연결 [standby]
mysql> change master to
master_host='30.45.45.4',
master_user='repl',
master_password='!dlatl00',
master_port=43306,
master_log_file='mysql-bin.000001',
master_log_pos=453;
mysql> start slave;
mysql> show slave staus\G