1 files changed, 37 insertions, 0 deletions
diff --git a/support-files/mysql-log-rotate.sh b/support-files/mysql-log-rotate.sh
new file mode 100644
index 00000000..37ae018c
--- /dev/null
+++ b/support-files/mysql-log-rotate.sh
@@ -0,0 +1,37 @@
+# This logname can be set in /etc/my.cnf
+# by setting the variable "log-error"
+# in the [mysqld] section as follows:
+#
+# [mysqld]
+# log-error=@localstatedir@/mysqld.log
+#
+# If the root user has a password you have to create a
+# /root/.my.cnf configuration file with the following
+# content:
+#
+# [mysqladmin]
+# password = <secret> 
+# user= root
+#
+# where "<secret>" is the password. 
+#
+# ATTENTION: This /root/.my.cnf should be readable ONLY
+# for root !
+
+@localstatedir@/mysqld.log {
+        # create 600 mysql mysql
+        notifempty
+        daily
+        rotate 3
+        missingok
+        compress
+    postrotate
+	# just if mariadbd is really running
+	if test -x @bindir@/mysqladmin && \
+	   @bindir@/mysqladmin ping &>/dev/null
+	then
+	   @bindir@/mysqladmin --local flush-error-log \
+              flush-engine-log flush-general-log flush-slow-log
+	fi
+    endscript
+}