sql replication 성공
2020.02.20 21:51
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
154 | mysql 암호화 [2] | WHRIA | 2020.04.24 | 47 |
153 | insync | WHRIA | 2023.02.09 | 47 |
152 | youtube | WHRIA | 2016.09.30 | 46 |
151 | sql 중복제거 | WHRIA | 2020.02.10 | 46 |
150 | exif javascript orientation | WHRIA | 2020.04.30 | 46 |
149 | annotation service | WHRIA | 2020.05.03 | 46 |
148 | melanoma awareness [1] | WHRIA | 2019.12.27 | 45 |
147 | batch normalize | WHRIA | 2020.02.06 | 45 |
146 | zerohq encryption [5] | WHRIA | 2020.04.23 | 45 |
145 | multiple NIC ubuntu [6] | WHRIA | 2020.03.10 | 44 |
144 | webapp [1] | WHRIA | 2020.05.10 | 44 |
143 | 서피스 3 질렀다. ㅎㅎ | WHRIA | 2015.12.15 | 43 |
142 | acquihire [1] | WHRIA | 2020.05.05 | 43 |
141 | raid 6 | WHRIA | 2020.07.23 | 43 |
140 | onnx broswer | WHRIA | 2020.09.15 | 43 |
mysqldump --skip-lock-tables --single-transaction --flush-logs --hex-blob --master-data=2 -A > ~/dump.sql
Now, examine the head of the file and jot down the values for MASTER_LOG_FILE and MASTER_LOG_POS. You will need them later:
head dump.sql -n80 | grep "MASTER_LOG_POS"