mysql数据库清理mysql-bin的日志文件

<?php
/**
 * User: K.O
 * Date: 2021.11.20
 * 1.批量将MyISAM引擎转换为InnoDB
 * 2.清理mysql mysql-bin.000005 日志文件
 */
set_time_limit(0);
$host='127.0.0.1';
$user='root';
$pwd='root';
$con=mysqli_connect($host,$user,$pwd);
if(mysqli_connect_errno($con)){echo '连接 MySQL 失败: '.mysqli_connect_error();}
//清理mysql mysql-bin.000005 日志文件
mysqli_query($con,"reset master");
mysqli_query($con,"PURGE MASTER LOGS TO 'mysql-bin.000164'");	//清理mysql-bin.000164之前的
mysqli_query($con,"PURGE MASTER LOGS BEFORE '2021-11-20 15:49'");//清理日期之前的
mysqli_query($con,"flush logs");	//删除日志
mysqli_close($con);

如果觉得本站内容对你有益，可对本站赞助，本站会不定时发布高质量内容。