Zabbix Database Cleanup and backup

[vlam]

Hi

Has anyone had any success in doing a backup of all Zabbix data in MySQL database older than "a certain amount of days" but att he same time remove that data out of the database.

Please I have a fiew systems where we are running on high Database usage.

Thanks

[soulhunter]

Hi

Has anyone had any success in doing a backup of all Zabbix data in MySQL database older than "a certain amount of days" but att he same time remove that data out of the database.

Please I have a fiew systems where we are running on high Database usage.

Thanks

I do not use MySQL (running on PostgreSQL), but I think you could partition the tables by date, then you can backup the older partitions and delete them.

[SangOr]

Yes you can

USER=
PASSWD=
BASE='zabbix'

DATE = `date "+%Y-%m-%d"`
service zabbix-server stop
mkdir /home/zabbix/backupDB

mysqldump -u$USER -p$PASSWD $BASE > /home/zabbix/backupDB/backup_Zabbix_$DATE.sql

service zabbix-server start

And restore with :

USER=
PASSWD=
BASE='zabbix'

DATE = `date "+%Y-%m-%d"`

service zabbix-server stop

mysql -u$USER -p$PASSWD $BASE < /home/zabbix/backupDB/backup_Zabbix_$DATE.sql

service zabbix-server start

U can create an other variable for the first script :

$PREV =`date -d '3days ago' "+%Y-%m-%d"`

and add this line at the end of script :

rm -f /home/zabbix/backupDB/backup_Zabbix_$PREV.sql

After, u can edit /etc/crontab for execute automatically your script each day

I hope that I helped u and sorry for my english.