2,187
edits
Difference between revisions of "MySQL"
Jump to navigation
Jump to search
m
→Remove Old Binary Logs: Updated
m (→Maintenance: Added Remove Old Binary Logs) |
m (→Remove Old Binary Logs: Updated) |
||
| Line 315: | Line 315: | ||
Make sure that any Slave's are up to date before deleting old binary logs | Make sure that any Slave's are up to date before deleting old binary logs | ||
<source lang="mysql"> | <source lang="mysql"> | ||
SHOW MASTER STATUS\g | SHOW MASTER STATUS\g | ||
SHOW MASTER LOGS; # Get list of logfiles | |||
PURGE MASTER LOGS TO 'mysql-bin.012344'; # Removes all logs up to the one specified | PURGE MASTER LOGS TO 'mysql-bin.012344'; # Removes all logs up to the one specified | ||
</source> | </source> | ||