In which table are settings stored?

[Marcus]

My testforum is using my real-life database but I have to switch off "save templates as file". Do you know the database table I have to take a look into? xf_addon is just for addons, and xf_option just defines the options :/

 

[Rigel Kentaurus]

select * from xf_data_registry where data_key='options'

 

[Marcus]

Is the whole xenForo data stored in one blob?

Last week I changed a setting directly in the database (and not a blob) to do something similar, I forgot if it was forum software xenforo or another one.

 

[Chris D]

The setting for save templates as files is stored in xf_option but changing it there won't immediately take effect as it is cached where Rigel says (delete that row after altering the setting in xf_option)

admin.php?options/list/performance#_templateFiles

The option ID is templateFiles

 

[v8td]

Where is stored SMTP settings?
Thanks!

 

[Chris D]

Admin CP > Options > Email Options

The data for all options can be found in the xf_option table.

There should rarely be a need to view or modify this data directly in the database, however.