/var/log/mysql/err {
	olddir /var/log/archiv/mysql
        notifempty
	create 640 mysql mysql
        prerotate
        	/usr/bin/mysqladmin --defaults-file=/etc/mysqld.conf flush-logs
	endscript

	postrotate
		/usr/bin/mysqladmin --defaults-file=/etc/mysqld.conf flush-logs
	endscript
}

/var/log/mysql/log {
	olddir /var/log/archiv/mysql
        notifempty
	missingok
	create 640 mysql mysql

        prerotate
        	/usr/bin/mysqladmin --defaults-file=/etc/mysqld.conf flush-logs
	endscript

	postrotate
		/usr/bin/mysqladmin --defaults-file=/etc/mysqld.conf flush-logs
	endscript
}

/var/log/mysql/isamlog {
	olddir /var/log/archiv/mysql
        notifempty
	missingok
	create 640 mysql mysql

        prerotate
        	/usr/bin/mysqladmin --defaults-file=/etc/mysqld.conf flush-logs
	endscript

	postrotate
		/usr/bin/mysqladmin --defaults-file=/etc/mysqld.conf flush-logs
	endscript
}

/var/log/mysql/update {
        olddir /var/log/archiv/mysql
        notifempty
        missingok
        create 640 mysql mysql

        prerotate
                /usr/bin/mysqladmin --defaults-file=/etc/mysqld.conf flush-logs
        endscript

        postrotate
                /usr/bin/mysqladmin --defaults-file=/etc/mysqld.conf flush-logs
        endscript
}