We're wanting to create a (massive) list of all of our Moodle site settings (including all plugin settings, roles and permissions, etc) - partly in order to compare our Moodle installations and where they differ. In browsing through the database, I have found a number of tables that do obviously contain settings (for instance, mdl_assign_plugin_config, but they are many, disparate and not necessarily easy to identify programmatically (at least, to my eyes). Has anyone out there built a script that will work through the entire DB and compile this list, even if it's just for Moodle core? Or is there documentation that could help me (by identifying where and how settings are stored) build such a script? We are currently running 2.5.9 and will be upgrading shortly to 2.7.4.
Thanks,
Trevar