MySQL 3.23, 4.0, 4.1 Reference Manual :: 8 Client and Utility Programs :: 8.20 mysql_find_rows — Extract Queries from Update Log
Section Navigation [Toggle]
- 8 Client and Utility Programs
- 8.1 Overview of Client and Utility Programs
- 8.2 my_print_defaults — Display Options from Option Files
- 8.3 myisam_ftdump — Display Full-Text Index information
- 8.4 myisamchk — MyISAM Table-Maintenance Utility
- 8.5 myisamlog — Display MyISAM Log File Contents
- 8.6 myisampack — Generate Compressed, Read-Only MyISAM Tables
- 8.7 mysql — The MySQL Command-Line Tool
- 8.8 mysqlaccess — Client for Checking Access Privileges
- 8.9 mysqladmin — Client for Administering a MySQL Server
- 8.10 mysqlbinlog — Utility for Processing Binary Log Files
- 8.11 mysqlcheck — A Table Maintenance and Repair Program
- 8.12 mysqldump — A Database Backup Program
- 8.13 mysqlhotcopy — A Database Backup Program
- 8.14 mysqlimport — A Data Import Program
- 8.15 mysqlmanagerc — Internal Test-Suite Program
- 8.16 mysqlmanager-pwgen — Internal Test-Suite Program
- 8.17 mysqlshow — Display Database, Table, and Column Information
- 8.18 mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
- 8.19 mysql_explain_log — Use EXPLAIN on Statements in Query Log
- 8.20 mysql_find_rows — Extract Queries from Update Log
- 8.21 mysql_fix_extensions — Make Table Filename Extensions Lowercase
- 8.22 mysql_setpermission — Interactively Set Permissions in Grant Tables
- 8.23 mysql_tableinfo — Generate Database Metadata
- 8.24 mysql_waitpid — Kill Process and Wait for Its Termination
- 8.25 mysql_zap — Kill Processes That Match a Pattern
- 8.26 perror — Explain Error Codes
- 8.27 replace — A String-Replacement Utility
- 8.28 resolveip — Resolve Hostname to IP Address or Vice Versa
- 8.29 resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols
mysql_find_rows reads update log files and
extracts queries that match a given regular expression or that
contain USE
or
db_nameSET statements.
Invoke mysql_find_rows like this:
shell> mysql_find_rows [options] [file_name ...]
Each file_name argument should be
the name of an updat log file. If no filenames are given,
mysql_find_rows reads the standard input.
Examples:
mysql_find_rows --regexp=problem_table --rows=20 < update.log mysql_find_rows --regexp=problem_table update-log.1 update-log.2
mysql_find_rows supports the following options:
User Comments
Add your own comment.