check in openstack db cleanup tool

[plstackapi.git] / planetstack / openstack / openstack-db-cleanup.sh

diff --git a/planetstack/openstack/openstack-db-cleanup.sh b/planetstack/openstack/openstack-db-cleanup.sh
deleted file mode 100755 (executable)
index 9baca6e..0000000
--- a/planetstack/openstack/openstack-db-cleanup.sh
+++ /dev/null
@@ -1,16 +0,0 @@
-#! /bin/bash
-
-# to install
-#    chmod 0755 /opt/planetstack/openstack/openstack-db-cleanup.sh
-#    ln -s /opt/planetstack/openstack/openstack-db-cleanup.sh /etc/cron.daily/openstack-db-cleanup.cron
-
-mkdir -p /opt/planetstack/ovs-backups
-BACKUP_NAME=/opt/planetstack/ovs-backups/backup-`date "+%Y-%M-%d"`.sql
-mysqldump --create-options --routines --triggers --databases keystone ovs_quantum nova glance cinder > $BACKUP_NAME
-gzip $BACKUP_NAME
-
-mysql keystone -e "DELETE FROM token WHERE NOT DATE_SUB(CURDATE(),INTERVAL 2 DAY) <= expires;"
-mysqlcheck --optimize --databases keystone ovs_quantum nova glance cinder
-
-date >> /var/log/openstack-db-cleanup.log
-mysql keystone -e "select count(*) from token;" >> /var/log/openstack-db-cleanup.log