How to Find Where the General Configuration is Stored in the Database
Always backup your data before performing any modifications to the database.
Under some circumstances, you may have the need to alter a field in the General Configuration, and cannot do so via the Admin interface.
The General Configuration is stored in the database in the
bandana
table.
Run the following query to see the settings:
SELECT * FROM bandana WHERE bandanakey = 'atlassian.confluence.settings';
A sample settings looks like:
BANDANAID | BANDANACONTEXT | BANDANAKEY | BANDANAVALUE |
1 | _GLOBAL | atlassian.confluence.settings | <settings> |