sql replication 성공
2020.02.20 21:51
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
154 | CIDR 표기법 [1] | WHRIA | 2020.03.12 | 45 |
153 | mysql 암호화 [2] | WHRIA | 2020.04.24 | 45 |
152 | annotation service | WHRIA | 2020.05.03 | 45 |
151 | 식약청 메뉴 | WHRIA | 2020.05.14 | 45 |
150 | batch normalize | WHRIA | 2020.02.06 | 44 |
149 | zerohq encryption [5] | WHRIA | 2020.04.23 | 44 |
148 | exif javascript orientation | WHRIA | 2020.04.30 | 44 |
147 | multiple NIC ubuntu [6] | WHRIA | 2020.03.10 | 43 |
146 | raid 6 | WHRIA | 2020.07.23 | 43 |
145 | nvidia docker | WHRIA | 2020.01.15 | 42 |
144 | acquihire [1] | WHRIA | 2020.05.05 | 42 |
143 | onnx broswer | WHRIA | 2020.09.15 | 42 |
142 | 서피스 3 질렀다. ㅎㅎ | WHRIA | 2015.12.15 | 41 |
141 | webapp [1] | WHRIA | 2020.05.10 | 41 |
» | sql replication 성공 [1] | WHRIA | 2020.02.20 | 40 |
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"