2,187
edits
Difference between revisions of "MySQL"
Jump to navigation
Jump to search
→Maintenance: Added "Restart Replication"
m (→Maintenance: Added "Skip Replication Errors") |
(→Maintenance: Added "Restart Replication") |
||
| Line 319: | Line 319: | ||
START SLAVE; | START SLAVE; | ||
</source> | </source> | ||
=== Restart Replication === | |||
If replication is completely broken, or the slave no longer has an accurate copy of the master. | |||
# Create dump from master | |||
#* <code> mysqldump -u root -p --master-data --all-databases --flush-privileges | gzip -1 > /var/tmp/replication.sql.gz </code> | |||
# Copy to slave | |||
#* EG <code> scp /var/tmp/replication.sql.gz root@10.1.1.55:/var/tmp/. </code> | |||
# Stop slave if still running | |||
#* In MySQL - <code>STOP SLAVE;</code> | |||
# Import into slave | |||
#* <code> zcat /var/tmp/replication.sql.gz | mysql -u root -p</code> | |||
# Start slave | |||
#* In MySQL - <code>START SLAVE;</code> | |||
=== Remove Old Binary Logs === | === Remove Old Binary Logs === | ||