sql replication 성공
2020.02.20 21:51
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
1744 | Sinhala - සිංහල | WHRIA | 2024.05.24 | 0 |
1743 | Slovak - slovenčina | WHRIA | 2024.05.24 | 0 |
1742 | Slovenian - slovenščina | WHRIA | 2024.05.24 | 0 |
1741 | Somali - Soomaali | WHRIA | 2024.05.24 | 0 |
1740 | Southern Sotho - Southern Sotho | WHRIA | 2024.05.24 | 0 |
1739 | Spanish - español | WHRIA | 2024.05.24 | 0 |
1738 | Sundanese - Basa Sunda | WHRIA | 2024.05.24 | 0 |
1737 | Swahili - Kiswahili | WHRIA | 2024.05.24 | 0 |
1736 | Swedish - svenska | WHRIA | 2024.05.24 | 0 |
1735 | Tajik - тоҷикӣ | WHRIA | 2024.05.24 | 0 |
1734 | Tamil - தமிழ் | WHRIA | 2024.05.24 | 0 |
1733 | Telugu - తెలుగు | WHRIA | 2024.05.24 | 0 |
1732 | Thai - ไทย | WHRIA | 2024.05.24 | 0 |
1731 | Turkish - Türkçe | WHRIA | 2024.05.24 | 0 |
1730 | Ukrainian - українська | WHRIA | 2024.05.24 | 0 |
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"