General discussion on installation and configuration of SOGo

Text archives Help


Re: [SOGo] Orphaned database tables in mysql backend?


Chronological Thread 
  • From: "Peter Schmidt" ( ) < >
  • To:
  • Subject: Re: [SOGo] Orphaned database tables in mysql backend?
  • Date: Wed, 19 Oct 2016 12:12:51 +0200
  • Dmarc-filter: OpenDMARC Filter v1.2.0 mail.inverse.ca BEC381204EAA

Is there really no one, that can tell me how to deal with tables that remain in the database after users or their folders (calendars, address books) have been deleted?

Kind regards,

Peter

Am 2016-10-06 um 17:33 schrieb Peter Schmidt
( ):
Hi there!

I found that my sogo mysql database has 179 tables.
5 of them are used for account data, namely:
sogo_folder_info
sogo_sessions_folder
sogo_user_profile
sogousers
sogousersource (actually this a view)

The remaining 174 tables contain user content and appear in a group of 3
tables named "sogoXX", "sogoXX_acl" and "sogoXX_quick".
Math shows us, there are 58 versions of "XX", but I only have 2 users
with a total of 6 folders. So to my understanding, I only need 18 of
these 174 tables.
What about the remaining ones? Is there a maintenance command to drop
unused tables or do I need to delete them manually?

Kind regards,

Peter



Archive powered by MHonArc 2.6.18.

Top of page