sql replication 성공
2020.02.20 21:51
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
1639 | image encryption [1] | WHRIA | 2020.04.24 | 82 |
1638 | zerohq encryption [5] | WHRIA | 2020.04.23 | 61 |
1637 | 의료영상분석장치 분류 코드 | WHRIA | 2020.04.22 | 56 |
1636 | 회귀분석 종류 | WHRIA | 2020.04.14 | 46 |
1635 | fcitx | WHRIA | 2020.04.05 | 75 |
1634 | chatbot | WHRIA | 2020.04.03 | 56 |
1633 | kernel load | WHRIA | 2020.04.03 | 47 |
1632 | plum | WHRIA | 2020.04.03 | 74 |
1631 | zmq async client server [1] | WHRIA | 2020.03.12 | 69 |
1630 | CIDR 표기법 [1] | WHRIA | 2020.03.12 | 75 |
1629 | multiple NIC ubuntu [6] | WHRIA | 2020.03.10 | 55 |
1628 | calendar javascript dropdown | WHRIA | 2020.03.01 | 41 |
» | sql replication 성공 [1] | WHRIA | 2020.02.20 | 50 |
1626 | sql 중복제거 | WHRIA | 2020.02.10 | 49 |
1625 | airplane | WHRIA | 2020.02.10 | 200 |
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"