Been meaning to do this for some time, in the end was quite easy. All the information needed is in http://wiki.znc.in/MySQL_Log
- Download the mod
- Build with
znc-buildmod mysql_log.cpp
- Copy compiled mod to the modules directory in ZNC
- Create database and table in MySQL
- Load with
loadmod mysql_log <DB user> <DB password> <DB host> <DB name> <Table name>
It’s alive!