Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revision | |||
| public:mysql [2022/08/04 15:35] – fix indent Nico | public:mysql [2026/04/05 11:06] (current) – [duplicate entry in replication] cosmetic fixes Nico | ||
|---|---|---|---|
| Line 161: | Line 161: | ||
| * stop slave | * stop slave | ||
| - | < | + | |
| + | ```sql | ||
| mysql> STOP SLAVE; | mysql> STOP SLAVE; | ||
| - | </ | + | ``` |
| * either manually delete the duplicate entry, or skip counter by issuing: | * either manually delete the duplicate entry, or skip counter by issuing: | ||
| - | < | + | |
| + | ```sql | ||
| mysql> SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; | mysql> SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; | ||
| - | </ | + | ``` |
| * start slave | * start slave | ||
| - | < | + | |
| + | ```sql | ||
| mysql> START SLAVE; | mysql> START SLAVE; | ||
| - | </ | + | ``` |
| ==== rebuild database indexes ==== | ==== rebuild database indexes ==== | ||