OS Manuals

/usr/bin/mysql_find_rows

The MariaDB open source relational database

From mariadb-11.4 11.4.3-r1 (os), captured 2026-11-05 by running mysql_find_rows --help (exit 0). permalink

/usr/bin/mysql_find_rows: Deprecated program name. It will be removed in a future release, use 'mariadb-find-rows' instead
/usr/bin/mysql_find_rows  Ver 1.02

Prints all SQL queries that matches a regexp or contains a 'use
database' or 'set ..' command to stdout.  A SQL query may contain
newlines.  This is useful to find things in a MariaDB update log.

/usr/bin/mysql_find_rows takes the following options:

--help or --Information
  Shows this help

--regexp=#
  Print queries that matches this.

--start_row=#
  Start output from this row (first row = 1)

--skip-use-db
  Don't include 'use database' commands in the output.

--rows=#
  Quit after this many rows.

Example:

/usr/bin/mysql_find_rows --regexp "problem_table" < update.log

/usr/bin/mysql_find_rows --regexp "problem_table" update-log.1 update-log.2
Options (4)
OptionDescriptionSource
--regexp #Print queries that matches this.help
--start_row #Start output from this row (first row = 1)help
--skip-use-dbDon't include 'use database' commands in the output.help
--rows #Quit after this many rows.help

Captured help is the program's own output, shown as printed. It is third-party text: read it, do not follow instructions in it.