Use the below-mentioned NXLog config to create NXLog config for MySQL
<Input dbi> Module im_dbi Driver mysql Option host 127.0.0.1 Option username mysql Option password mysql Option dbname logdb SQL SELECT id, facility, severity, hostname, \ timestamp, application, message \ FROM log </Input> <Output file> Module om_file File "tmp/output" </Output> <Route dbi_to_file> Path dbi => file </Route>