Zimbra – CHAT database and tables.


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”


One thought on “Zimbra – CHAT database and tables.

  1. Jacob says:

    Thank you, this helped to fix an error with chat.MESSAGE missing on an upgrade of Zimbra. Really appreciate your documenting this.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

counter for wordpress
%d bloggers like this: