2,187
edits
Difference between revisions of "MySQL"
Jump to navigation
Jump to search
m
→Maintenance: Added "Skip Replication Errors"
m (→Remove Old Binary Logs: Updated) |
m (→Maintenance: Added "Skip Replication Errors") |
||
| Line 310: | Line 310: | ||
<source lang="mysql"> | <source lang="mysql"> | ||
OPTIMIZE TABLE SystemEvents; | OPTIMIZE TABLE SystemEvents; | ||
</source> | |||
=== Skip Replication Errors === | |||
Sometimes replication to a Slave will stop due to an error. To skip the error and restart replication, perform the following on the slave... | |||
<source lang="mysql"> | |||
STOP SLAVE; | |||
SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; | |||
START SLAVE; | |||
</source> | </source> | ||