zh:notes:install_mysql
差别
这里会显示出您选择的修订版和当前版本之间的差别。
| 两侧同时换到之前的修订记录 前一修订版 后一修订版 | 前一修订版 | ||
|
zh:notes:install_mysql [2023/07/30 17:26] pzczxs [Firewall Configuration] |
zh:notes:install_mysql [2023/07/30 17:38] (当前版本) pzczxs [Remove binlog files] |
||
|---|---|---|---|
| 行 70: | 行 70: | ||
| ===== Remove binlog files ===== | ===== Remove binlog files ===== | ||
| + | The location of binlog files can be shown by using the following commands. | ||
| + | <code bash> | ||
| + | > mysql -uroot -p | ||
| + | > show binary logs; | ||
| + | </code> | ||
| + | The binlog files can be removed by using the following commands. | ||
| + | <code bash> | ||
| + | > RESET MASTER; // remove all binlog files. | ||
| + | > PURGE MASTER LOGS to "binlog.000100"; // remove all binlog files before "binlog.000100" | ||
| + | > PURGE MASTER LOGS BEFORE "2023-07-28 22:00:00"; // remove all binlog files before 2023-07-28 22:00:00 | ||
| + | </code> | ||
| ~~DISCUSSION:closed~~ | ~~DISCUSSION:closed~~ | ||
zh/notes/install_mysql.1690709206.txt.gz · 最后更改: 2023/07/30 17:26 由 pzczxs