sql replication 성공
2020.02.20 21:51
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
1819 |
이건 비밀글이얍
![]() | J | 2004.04.23 | 2 |
1818 | Odia - ଓଡ଼ିଆ | WHRIA | 2024.05.24 | 2 |
1817 |
아저씨에게
[1] ![]() | ^&^ | 2004.04.25 | 3 |
1816 | Russian - русский | WHRIA | 2024.05.24 | 3 |
1815 | Galician - galego | WHRIA | 2024.05.24 | 4 |
1814 | Malay - bahasa Malaysia | WHRIA | 2024.05.24 | 4 |
1813 | Maltese - Malti | WHRIA | 2024.05.24 | 4 |
1812 | Norwegian - norsk | WHRIA | 2024.05.24 | 4 |
1811 |
아저씨~
[1] ![]() | ^&^ | 2004.05.15 | 5 |
1810 | Gujarati - ગુજરાતી | WHRIA | 2024.05.24 | 5 |
1809 | Latvian - latviešu | WHRIA | 2024.05.24 | 5 |
1808 | Macedonian - македонски | WHRIA | 2024.05.24 | 5 |
1807 | Hungarian - magyar | WHRIA | 2024.05.24 | 6 |
1806 | Māori - te reo Māori | WHRIA | 2024.05.24 | 6 |
1805 | Nepali - नेपाली | WHRIA | 2024.05.24 | 6 |
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"