sql replication 성공
2020.02.20 21:51
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
139 | CE | WHRIA | 2020.05.17 | 57 |
138 | 학술저널 받는법 | WHRIA | 2015.11.30 | 56 |
137 | chatbot | WHRIA | 2020.04.03 | 56 |
136 | exif javascript orientation | WHRIA | 2020.04.30 | 56 |
135 | raid 6 | WHRIA | 2020.07.23 | 56 |
134 | lvm 확장 [1] | WHRIA | 2019.12.25 | 55 |
133 | nvidia caffe | WHRIA | 2020.01.12 | 55 |
132 | annotation service | WHRIA | 2020.05.03 | 55 |
131 | DDR-WRT IPTV | WHRIA | 2016.06.15 | 54 |
130 | MedicalPhoto MSVC 2015 와 최신 boost 로... | WHRIA | 2016.08.26 | 54 |
129 | git 특정 버젼 | WHRIA | 2020.07.11 | 54 |
128 | Visual Studio 설치후 Excel 2002 (XP) 종료시 에러 문제 | WHRIA | 2015.11.20 | 53 |
127 | melanoma awareness [1] | WHRIA | 2019.12.27 | 53 |
126 | nvidia docker | WHRIA | 2020.01.15 | 53 |
125 | android / capture and crop [5] | WHRIA | 2020.05.10 | 52 |
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"