Log File too Large, Need to Archive it & Create a New one | MySQL
Because of the Log File too large, needed to archive it & create a new one
mysqld.log at /var/log/
If not run "install -omysql -gmysql -m0644 /dev/null /var/log", because of the permission, get:
Update
-rw-r-----. 1 mysql mysql 24911815759 Dec 31 14:20 mysqld.log
mysqld.log at /var/log/
/etc/my.cnf:
general_log=/var/log/mysqld.log
general_log=1
general_log=/var/log/mysqld.log
general_log=1
$ cd /var/log
$ sudo mv mysql.log mysql.old
$ sudo install -omysql -gmysql -m0644 /dev/null /var/log/mysqld.log
$ sudo mysqladmin -p flush-logs
$ sudo mv mysql.log mysql.old
$ sudo install -omysql -gmysql -m0644 /dev/null /var/log/mysqld.log
$ sudo mysqladmin -p flush-logs
If not run "install -omysql -gmysql -m0644 /dev/null /var/log", because of the permission, get:
mysqladmin: refresh failed; error: 'File '/var/log/mysqld.log' not found (Errcode: 13)'
Update