sql replication 성공
2020.02.20 21:51
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
1789 | Icelandic - íslenska | WHRIA | 2024.05.24 | 8 |
1788 | Irish - Gaeilge | WHRIA | 2024.05.24 | 8 |
1787 | Kyrgyz - кыргызча | WHRIA | 2024.05.24 | 8 |
1786 | Lithuanian - lietuvių | WHRIA | 2024.05.24 | 8 |
1785 | Malagasy - Malagasy | WHRIA | 2024.05.24 | 8 |
1784 | Punjabi - ਪੰਜਾਬੀ | WHRIA | 2024.05.24 | 8 |
1783 | Turkish - Türkçe | WHRIA | 2024.05.24 | 8 |
1782 | Western Frisian - Frysk | WHRIA | 2024.05.24 | 8 |
1781 | Xhosa - isiXhosa | WHRIA | 2024.05.24 | 8 |
1780 | Haitian Creole - Haitian | WHRIA | 2024.05.24 | 9 |
1779 | Luxembourgish - Lëtzebuergesch | WHRIA | 2024.05.24 | 9 |
1778 | Nyanja - Nyanja | WHRIA | 2024.05.24 | 9 |
1777 | Polish - polski | WHRIA | 2024.05.24 | 9 |
1776 | Portuguese - português | WHRIA | 2024.05.24 | 9 |
1775 | Sindhi - سنڌي | WHRIA | 2024.05.24 | 9 |
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"