---
name: "mysql2dlf"
section: "1"
platform: "linux"
package: "lire"
version: "2.1.1-8"
release: "Arch Linux 2026-11-01"
platforms: ["linux"]
url: "https://new.carta.tech/mysql2dlf"
---

# mysql2dlf(1)

convert mysql logfiles to dlf format

## NAME

mysql2dlf - convert mysql logfiles to dlf format

## SYNOPSIS

**mysql2dlf**

## DESCRIPTION

**mysql2dlf** converts a MySQL query log file to DLF format.  Information on MySQL can be found on http://www.mysql.org/. The query log file is defined by the --log\[=file\] option of **mysqld**, or the log=file setting in MySQL configuration file.

Such a log file looks like e.g.

```
 /usr/sbin/mysqld, Version: 3.23.43-debug-log, started with:
 Tcp port: 3306  Unix socket: /var/run/mysqld/mysqld.sock
 Time                 Id Command    Argument
 011218 15:02:58       1 Connect     root@localhost on
                       1 Query       SHOW VARIABLES LIKE 'pid_file'
                       1 Shutdown
 011226 21:35:59       6 Connect     joe@localhost on
                       6 Init DB     nmrshiftdb
                       6 Query       SHOW VARIABLES
```

or

```
                  42401 Query       SELECT
                  bannerID,
                  banner,
                  format,
                  width,
                  height,
                  alt,
                  url
              FROM
                  banners
              WHERE
                  act = 'true'  AND (keyw = 'fullsize' OR keyw = 'global')
```

The generic database dlf format is described in database.xml.

## EXAMPLES

To process a log as produced by MySQL:

```
 $ mysql2dlf < mysql-log
```

mysql2dlf will be rarely used on its own, but is more likely called by lr\_log2report:

```
 $ lr_log2report mysql < /var/log/mysql-log
```

## NOTES

The parser has been tested for query log files for MySQL 3.23.46 only.

## BUGS

This converter stores all log files information in one big nested array in memory, before writing.  Therefore, memory consumption is linear with the size of the log.

## SEE ALSO

[**mysql**(1)](/mysql/1.md), [**mysqld**(1)](/mysqld/1.md)

## VERSION

`$Id:` mysql2dlf.in,v 1.12 2010/12/05 20:36:45 wraay Exp $

## COPYRIGHT

Copyright (C) 2001, 2002 Stichting LogReport Foundation LogReport@LogReport.org

This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with this program (see COPYING); if not, check with http://www.gnu.org/copyleft/gpl.html.

## AUTHOR

Egon Willighagen \<egonw@logreport.org\>