- fix mysql 4.1.1 migration trigger where one has leading space in cluster definition

[packages/mysql.git] / mysql.logrotate

diff --git a/mysql.logrotate b/mysql.logrotate
index c9956d6b8ff5ea49cd0126fd5dd7acbffcf182a4..988c60d22450da71e1981856d142e7b53d2bff49 100644 (file)
--- a/mysql.logrotate
+++ b/mysql.logrotate
@@ -1,40 +1,21 @@
-/var/log/mysql/err {
-        notifempty
+# If the *mysql* root user has a password you have to set it in mysqld.conf
+#
+# [mysqladmin]
+# user = mysql_logrotate
+# password = <secret> 
+#
+# where "<secret>" is the password. 
+#
+# You must do this for every cluster defined in /etc/mysql/clusters.conf
+#
+# ATTENTION: The mysqld.conf should be readable ONLY for *system* root!
+
+/var/log/mysql/log /var/log/mysql/isamlog.log /var/log/mysql/update* {
+       olddir /var/log/archiv/mysql
+       notifempty
        create 640 mysql mysql
-        prerotate
-               /usr/bin/mysqladmin --defaults-file=$MYSQLD_CONFIG flush-logs
-       endscript
-
-       postrotate
-               /usr/bin/mysqladmin --defaults-file=$MYSQLD_CONFIG flush-logs
-       endscript
-}
-
-/var/log/mysql/log {
-        notifempty
-       missingok
-       create 640 mysql mysql
-
-        prerotate
-               /usr/bin/mysqladmin --defaults-file=$MYSQLD_CONFIG flush-logs
-       endscript
-
+       sharedscripts
        postrotate
-               /usr/bin/mysqladmin --defaults-file=$MYSQLD_CONFIG flush-logs
+               /etc/rc.d/init.d/mysql flush-logs
        endscript
 }
-
-/var/log/mysql/isamlog {
-        notifempty
-       missingok
-       create 640 mysql mysql
-
-        prerotate
-               /usr/bin/mysqladmin --defaults-file=$MYSQLD_CONFIG flush-logs
-       endscript
-
-       postrotate
-               /usr/bin/mysqladmin --defaults-file=$MYSQLD_CONFIG flush-logs
-       endscript
-}
-