April 8, 2019 by aubreykloppers
To recreate the CHAT database and tables is actually quite easy if you know how to do it. Unlike ZIMBRA support that made me run into circles when I asked them how to recreate the database from scratch they made me follow 2 weeks of instructions, just to tell me to drop the entire thing and recreate it.
It is actually quite easy:
- Make a copy of the /opt/zimbra/db/create_database.sql file, naming it “create_chat_database.sql”
- Delete lines 1to306 from the new file, basically everything from before “– Support for Zimbra Chat –“
- Run the file, creating the database with “mysql < create_chat_database.sql”