MySQL错误日志备份与重建（CentOS）

1、错误日志重命名

[root@centos7-03 log]# mv /var/log/mysqld.log /var/log/mysqld.log_old

2、重建错误日志

[root@centos7-03 log]# install -omysql -gmysql -m0644 /dev/null /var/log/mysqld.log
[root@centos7-03 log]# mysqladmin -u root -p flush-logs

 

注：只执行mysqladmin -u root -p flush-logs会报异常

[root@centos7-03 log]# mysqladmin -u root -p flush-logs
Enter password: 
mysqladmin: refresh failed; error: 'Could not open file '/var/log/mysqld.log' for error logging.'