Zimbra – CHAT database and tables.

Leave a comment

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”


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

%d bloggers like this: