MNET public key
All MNET host keys are stored in the table:
The id of the local MNET host key (your moodle) is stored in the config table in the
You can use the following to get the puglic key and MNET information about your local moodle. Also a good idea to back this up if it is a site with an MNET integration (e.g. Mahara) as it will break once the public key changes.
select * from mdl_mnet_host where id = ( select value from mdl_config where name = 'mnet_localhost_id' );