How to Reset and Reinitialize Logger DB?

[leog21]

We had some issues with the logger db, on 5.0.11, it was killing the box. We disabled it and it fixed the problems. We just upgraded to 5.0.16 and were wondering how we can reset and reinitialize the Logger DB before we turn on the service again?

Thanks,
Leo

[raj]

do exactly as below and it will delete everything for logger and create everything new for logger db

su - zimbra
logmysql.server stop
logout
rm -rf /opt/zimbra/logger/db/data/*
chown zimbra:zimbra /opt/zimbra/db/data
chmod 775 /opt/zimbra/db/data
cd /opt/zimbra/libexec
./zmloggerinit
./zmfixperms --verbose --extended
su - zimbra
zmlogswatchctl start
logout

Raj