I discovered that my db had some errors during my last update to version 8.8.11.
I corrected my database following this link https://wiki.zimbra.com/wiki/Mysql_Crash_Recovery
But, I "forgot" the chat db in the repair process, nevertheless, my zimbra works well in version 8.8.11without the chat db since I don't use/need it.
Now I want to upgrade it in version 8.8.15 but I get an fatal error during the install process because of "chat elements" missing.
I'm looking for a solution to correct the chat db or to remove the chat app in order to be able to upgrade.
<SOLVED> How to correct chat database or remove chat application/upgrade?
Re: <SOLVED> How to correct chat database or remove chat application/upgrade?
Don't know if there is a simpler method but what I did :
- Reactivate a backup
- Dump the chat db
- Reactivate my zimbra
- Recreate my chat db from the dump
- Reactivate a backup
- Dump the chat db
- Reactivate my zimbra
- Recreate my chat db from the dump
-
- Outstanding Member
- Posts: 258
- Joined: Thu May 12, 2016 1:56 pm
- Location: Belgium
- ZCS/ZD Version: 9.0.0
Re: <SOLVED> How to correct chat database or remove chat application/upgrade?
Take a look at the upgrade scripts for chat:
/opt/zimbra/libexec/scripts/migrate20170301-ZimbraChat.pl
/opt/zimbra/libexec/scripts/migrate20180301-ZimbraChat.pl
/opt/zimbra/libexec/scripts/migrate20190401-ZimbraChat.pl
/opt/zimbra/libexec/scripts/migrate20190611-ZimbraChat.pl
They contain the SQL statements to (re)create and upgrade the chat db.
/opt/zimbra/libexec/scripts/migrate20170301-ZimbraChat.pl
/opt/zimbra/libexec/scripts/migrate20180301-ZimbraChat.pl
/opt/zimbra/libexec/scripts/migrate20190401-ZimbraChat.pl
/opt/zimbra/libexec/scripts/migrate20190611-ZimbraChat.pl
They contain the SQL statements to (re)create and upgrade the chat db.